一、用编译根据navicat设置字段,并勾选主键
二、设置序号
CREATE SEQUENCE table_SEQ
minvalue 1
maxvalue 9999999999999999999
increment by 1
start with 1;
运行后序号会显示出来
三、设置触发器
CREATE OR REPLACE TRIGGER Trigger_table
BEFORE INSERT ON table
for each row
when(NEW.ID is NULL)
begin
select TB_BYCX_SEQ.Nextval into :NEW.ID from dual;
end;
运行后触发器会显示,且设置更新字段保存
完成设置,插入数据会自动更新