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.

 

 

"CREATE SEQUENCE  "RECORD_ID" MINVALUE

 

1     MAXVALUE      999999999999999999999999999

 

INCREMENT BY 1 START WITH 1000 CACHE 20

 

NOORDER  NOCYCLE If we use the command as

 

RecordId,Nextval will fetch the incremented value as

 

1001 and RecordId,Currval will fetch 1000, Once we use NextVal command, sequence will internally incremented and it will maintain uniqueness to supply next number, Using Apex ObJect Browser, creation of sequence is as follows:

Create SEQUENCE

 

Click CREATE in ObJect Browser img8.png select the

 

Sequence ObJect

 

img6.png      Type Voucher-seq in Sequence Name

 

img6.png      Give minimum value as 1

 

img6.png      Give Maximum value as

 

9999999999999999

 

img6.png      Give increment value as CLICK NEXT

 

img6.png Under Sequence window CLICK CREATE