1. 创建序列
create sequence user_sequence increment by 1 start with 20 minValue 20 maxValue 9999;
2. 创建自增键的触发器
SCOTT@orcl>create or replace trigger user_trigger
2 before insert3 on users
4 for each row when(new.user_id is null)
5 begin
6 select user_sequence.nextval into :new.user_id from dual;
7 end;
8 /