Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

The above method can be used to create sequence for voucher-seq, Ledger-seq, RECORD-ID-SEQ word alone need to be replaced with other sequence name, The following syntax can be typed in Home → SQL Workshop → SQL Command Window

Create sequence "VOUCHER_SEQ" minvalue 1

maxvalue

999999999999999999999999999999 Increment by 1 start with 1 nocache

Noorder nocycle    CLICK RUN will generate sequence,

Create sequence "LEDGER_SEQ" minvalue 1 maxvalue

999999999999999999999999999999 Increment by 1 start with 1 nocache

Noorder nocycle    CLICK RUN will generate sequence, Now our next problem is linking this sequence name into the field and initiating the action of populate, This will

be discussed in Trigger handling section,

In the next chapter, we like to see the creation of constraints like Primary Key, CHECK, UNIQUE, FOREIGN KEY,