建序列:
create sequence SQ_PUBLIC
minvalue 1
maxvalue 999999
start with 1
increment by 1;
建触发器:
SQL> create or replace trigger exam_tri
2 before insert on t_example
3 for each row
4 begin
5 select sq_public.nextval into:new.id from dual;
6 end dept_tri;
7 /
如果不用触发器的话,插入数据时,直接在ID字段插入SQ_PUBLIC.NEXTVAL。