(Oracle) sequence 생성, 사용하기

SQL> create sequence test_sq start with 100 increment by 50;

Sequence created.

SQL> desc test_sq;
SP2-0381: DESCRIBE sequence is not available

SQL> select test_sq.nextval, ename from emp where empno>0;
       100 SMITH
       150 ALLEN
       200 WARD
       250 JONES
       300 MARTIN
       350 BLAKE
       400 CLARK
       450 SCOTT
       500 KING
       550 TURNER
       600 ADAMS
       650 JAMES
       700 FORD
       750 MILLER

14 rows selected.

Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE
   1    0   SEQUENCE OF 'TEST_SQ'
   2    1     TABLE ACCESS (BY INDEX ROWID) OF 'EMP'
   3    2       INDEX (RANGE SCAN) OF 'PK_EMP' (UNIQUE)