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

/ Home / Computer & Internet / Oracle SQL, PLSQL, APEX How To's

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.

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