oracle触发器demo

CREATE OR REPLACE TRIGGER AFTER_TB_COL
after insert on TB_COL for each row
declare
  V_Id       USERS.ID%TYPE;
  V_UN       USERS.USERNAME%TYPE:='张三';
  V_PSW      USERS.PASSWORD%TYPE:='123';
begin
     SELECT SEQ_USERS.NEXTVAL INTO V_Id FROM DUAL;
     INSERT INTO USERS VALUES(V_Id,V_UN,V_PSW);
end;