1.identity columns。http://www.cndba.cn/hbhe0316/article/107884

SQL> create table ttt1 (
  2  id1 number generated by default as identity ,
  3  name varchar2(50)
  4  );

Table created.

SQL> insert into ttt1(name) values ('111');

1 row created.

SQL> insert into ttt1(name) values ('222');

1 row created.

SQL> insert into ttt1(name) values ('333');

1 row created.

SQL> commit;

Commit complete.

SQL> select * from ttt1;

       ID1
----------
NAME
--------------------------------------------------------------------------------
         1
111

         2
222

         3
333

2.使用generated by default
除了使用默认的序列生成器之外，也可以使用指定的序列来自增，或者仅当插入NULL 的时候才自增。http://www.cndba.cn/hbhe0316/article/107884

SQL> create table ttt2 (
  2  id1 number generated by default as identity ,
  3  name varchar2(50)
  4  );

Table created.

SQL> insert into TTT2(name) values ('aaa');

1 row created.

SQL> insert into TTT2 values(88,'bbb');

1 row created.

SQL> commit;

Commit complete.

SQL> select * from ttt2;

       ID1
----------
NAME
--------------------------------------------------------------------------------
         1
aaa

        88
bbb

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle