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,