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.
maintains only one record and frequently gets updated as the last sequence number to be assigned on requirement )
Column-Na me
Data Type 1
Width
Remarks
Record-Id
Number
If length is not specified default value will be taken as 22. This
column will be populated from the system generated sequence number
Ledger-seq
Number (
16, 0)
Length will be 16 and decimal portion will be
2 digits. This sequence will be used to generate Ledger-code with some concatenation of other values.
Voucher-seq
Number
This number will be
44