Get next value from sequence : Value « Sequences « Oracle PL/SQL Tutorial

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

SQL> create table emp(
  2           emp_id                integer         primary key
  3          ,lastname               varchar2(20)    not null
  4          ,firstname              varchar2(15)    not null
  5          ,midinit                varchar2(1)
  6          ,street                 varchar2(30)
  7          ,city                   varchar2(20)
  8          ,state                  varchar2(2)
  9          ,zip                    varchar2(5)
 10          ,shortZipCode                   varchar2(4)
 11          ,area_code              varchar2(3)
 12          ,phone                  varchar2(8)
 13          ,company_name           varchar2(50));

Table created.

SQL>
SQL> create sequence s_emp_id
  2  start with 1000;

Sequence created.

SQL>
SQL> insert into emp (emp_id, lastname, firstname)
  2  values   (s_emp_id.nextval, 'Einstein', 'Albert');

1 row created.

SQL>
SQL> drop table emp;

Table dropped.

SQL>
SQL> drop sequence s_emp_id;

Sequence dropped.