CREATE SEQUENCE [schema .] sequence
[{ { INCREMENT BY | START WITH } integer
 | { MAXVALUE integer | NOMAXVALUE }
 | { MINVALUE integer | NOMINVALUE }
 | { CYCLE | NOCYCLE }
 | { CACHE integer | NOCACHE }
 | { ORDER | NOORDER }
 } 
 [ { INCREMENT BY | START WITH } integer
 | { MAXVALUE integer | NOMAXVALUE }
 | { MINVALUE integer | NOMINVALUE }
 | { CYCLE | NOCYCLE }
 | { CACHE integer | NOCACHE }
 | { ORDER | NOORDER } 
 ]...
]
;
For information on the symbols and conventions of Backus-Naur Form (BNF) syntax, see Appendix A.

Oracle9i SQL Reference
Release  1  ( 9 . 0 . 1 )
Part Number A90125- 01 
SQL Statements: 
CREATE LIBRARY to CREATE SPFILE,  15  of  16  
CREATE SEQUENCE