Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview
PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.
Download the book in PDF, ePub, Kindle for a complete version.
Window
→ Sequences CREATE
→ sequences
→ CREATE Sequence
Window
→ record_id_seq
against
Sequence name
→ 1 against start with
→ 1 against Minimum
Value
100000000 against
Maximum Value
1 against increment by
leave other columns as Default Next CREATE
Create sequence "RECORD_ID_SEQ" minvalue 1 maxvalue
999999999999999999999
999999999
Increment by 1 start with
1 nocache
Noorder nocycle
102