触发器:
CREATE OR REPLACE TRIGGER LWLL.TLwllOperRecord2_TRG
BEFORE INSERT
ON TLwllOperRecord2
FOR EACH ROW
BEGIN
SELECT TLwllOperRecord2_ID_SEQ.NEXTVAL
INTO :NEW.ID
FROM DUAL;
END;
insert语句:
insert into lwll.TLwllOperRecord2(OpAcct,OpAcctType,OpToAcct,OpToAcctType,OpType,OpTime,OpState,OpState2,OpReason )values ('test3',1,'test3',1,3,sysdate,'12345678','123456','aaa')