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.

 

 

 

Window

 

Sequences CREATE

 

→  sequences

 

→ CREATE Sequence

 

Window

 

→ record_id_seq

 

against

 

Sequence name

→ 1 against start with

 

→ 1 against Minimum

 

Value

 

img8.png 100000000 against

 

Maximum Value

 

img8.png 1 against increment by

leave other columns as Default img8.png Next CREATE

Create sequence "RECORD_ID_SEQ" minvalue 1 maxvalue

999999999999999999999

 

999999999

 

Increment by 1 start with

 

1 nocache

 

Noorder nocycle

 

 

 

 

 

 

102