Automatically including unique sequence numbers during an INSERT. : Value « Sequences « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Sequences
3. Value

SQL>
SQL> create sequence mySeq start with 1000 increment by 1 cache 100;

Sequence created.

SQL>
SQL> create table myTable (col1 number primary key);

Table created.

SQL>
SQL> insert into myTable values (mySeq.nextval);

1 row created.

SQL> insert into myTable values (mySeq.nextval);

1 row created.

SQL>
SQL> select * from myTable;



      COL1
----------
      1000
      1001

2 rows selected.

SQL>
SQL> drop table myTable;

Table dropped.

SQL>
SQL> drop sequence mySeq;

Sequence dropped.