oracle 12c之前用sequence 和 trigger来生成自动增长的列
SQL> create table scott.t1 (id number, val varchar2(8));
Table created.
SQL> CREATE SEQUENCE scott.t1_id_seq INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE ;
Sequence created.
SQL> create or replace trigger scott.t1_id_trigger
2 before insert on scott.t1 for each row
3 begin
4 select scott.t1_id_seq.nextval into :new.id from dual;
5 end;
6 /
Trigger created.
SQL> insert into scott.t1(val) values(‘a‘);
1 row created.
SQL> commit;
Commit complete.
SQL> select * from scott.t1;
ID VAL
---------- ------------------------
1 a
SQL> insert into scott.t1(val) values(‘b‘);
1 row created.
SQL> select * from scott.t1;
ID VAL
---------- ------------------------
1 a
2 b
SQL> commit;
Commit complete.
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
