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

1. Oracle PL / SQL
2. Sequence
3. Sequence Value

Automatically including unique sequence numbers during an INSERT.

 

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.

   
  

Related examples in the same category