打开oracle sequences,Oracle Sequences

Sequence: Define a Sequence to generate sequential numbers automatically

example:可以在 update、select、insert语句中使用

SQL> ed

Wrote file afiedt.buf

1 create sequence test_seq

2 increment by 10

3 start with 100

4 maxvalue 200

5 minvalue 110

6 cycle

7* nocache

SQL> /

create sequence test_seq

*

ERROR at line 1:

ORA-04006: START WITH cannot be less than MINVALUE

SQL> ed

Wrote file afiedt.buf

1 create sequence test_seq

2 increment by 10

3 start with 120

4 maxvalue 200

5 minvalue 110

6 cycle

7* nocache

SQL> /

Sequence created.

SQL> select test_seq.nextval from dual;

NEXTVAL

----------

120

SQL> select test_seq.currval from dual

CURRVAL

----------

120

SQL>

Oracle Sequences

标签：div   efi   amp   ica   number   less   tar   bash   line

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源：https://www.cnblogs.com/jycjy/p/11505046.html