ID是主健,实现插入一个NAME,ID自动增加
SQL>create table t1(id number,name varchar2(10));
SQL>create sequence T1ID_SEQ
2 minvalue 1
3 maxvalue 999999
4 start with 1
5 increment by 1
6 cache 20;
创建触发器
sql> create or replace trigger tr
before insert on table for each row
begin
select to_char(seq.nextval) into :new.id form dual;
end tr;
/