几乎每天都有人问此问题,给你个参考:
http://expert.csdn.net/Expert/topic/1907/1907225.xml?temp=.1886713
http://expert.csdn.net/Expert/topic/1465/1465844.xml?temp=.8864862
http://expert.csdn.net/Expert/topic/1907/1907225.xml?temp=.1886713
http://expert.csdn.net/Expert/topic/1465/1465844.xml?temp=.8864862
引用时用sequencename.nextval
create sequence 序列名
increment by 1
start with 1
maxvalue 999999999
cycle;当向表中插入数据时,SQL语句写法如下;
SQL> insert into 表名 values(序列名.nextval,列1值,列2值);
minvalue 1
maxvalue 99999999
start with 1
increment by 1
/create trigger a_tri
before insert on a
for each row
as
begin
select seq_id.nextval into :new.id from dual;
end;
/