Oracle 表创建序列-触发 实现表ID自动增长

/
-- Create sequence
create sequence SEQ_表名
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;
/
create or replace trigger TRG_表名 before insert on

表明
for each row
begin
select SEQ_表明.nextval into :new.自动增长ID字段 from dual;
end;
/