ORACLE SEQUENCE

SQL> create table s_depart(
  2  departid int not null,
  3  departname nvarchar2(40) not null,
  4  departorder int default 0,
  5  constraint pk_s_depart primary key (departid)
  6  );

表已创建。

SQL> create sequence s_s_depart
  2  minvalue 1
  3  maxvalue 9999999999999999999999
  4  start with 1
  5  increment by 1
  6  nocache;

序列已创建。

SQL> insert into s_depart(departid,departname,departorder) values (s_s_depart.Ne
xtval,'12345',1);

已创建 1 行。

SQL> select empseq.cruuval from dual;
select empseq.cruuval from dual
       *
第 1 行出现错误:
ORA-00904: "EMPSEQ"."CRUUVAL": 标识符无效


SQL> select empseq.currval from dual;
select empseq.currval from dual
       *
第 1 行出现错误:
ORA-02289: 序列不存在


SQL> select s_s_depart.currval from dual;

   CURRVAL
----------
         1

SQL> select s_s_depart.nextval from dual;

   NEXTVAL
----------
         2

SQL> select s_s_depart.nextval from dual;

   NEXTVAL
----------
         3

SQL> select s_s_depart.nextval from dual;

   NEXTVAL
----------
         4

SQL> select s_s_depart.nextval from dual;

   NEXTVAL
----------
         5

SQL> select s_s_depart.nextval from dual;

   NEXTVAL
----------
         6

SQL> select s_s_depart.nextval from dual;

   NEXTVAL
----------
         7

SQL> select s_s_depart.nextval from dual;

   NEXTVAL
----------
         8

SQL> select s_s_depart.nextval from dual;

   NEXTVAL
----------
         9

SQL>