1、创建表
create table emp(
id number,
name varchar2(30)
);
2、创建序列
create sequence emp_sequence
minvalue 0
maxvalue 999999999999999999
start with 0
increment by 1
cache 20;
3、创建触发器
create trigger "emp_trigger"
before insert on
emp for each row
declare
begin
select emp_sequence.nextval into:new.id from dual;
end;