对数据表t_logsystem中的nkey字段设为自增字段
1.创建序列:
----创建序列create sequence logsystem_seq
increment by 1
start with 1
nomaxvalue
nominvalue
nocache;
2.创建触发器:
create or replace trigger tr_logsystem
before insert on t_logsystem
for each row
begin
<<COLUMN_SEQUENCES>>
BEGIN
IF INSERTING THEN
SELECT logsystem_seq.NEXTVAL INTO :NEW.NKEY FROM SYS.DUAL;
END IF;
END COLUMN_SEQUENCES;
end tr_logsystem;