oracle 自增序号

Oracle:

      --第一步：先创建序列

      SQL>CREATE SEQUENCE IDENTITY_ID START WITH 1 INCREMENT BY 1

      order

      nocycle;

      /

      --第二步：创建表

      SQL>CREATE TABLE TEMP(ID INT,NAME VARCHAR2(10))

      /

SQL>INSERT INTO TEMP VALUES(IDENTITY_ID.NEXTVAL,’ZHANG’);

SQL> select * from temp;

 

        ID NAME

---------- --------------------

         1 zhang