Record-id Number voucher-number char (10) ledger-code char(10)
voucher-naration varchar2(400), debit number(16,2), credit number(16,2))
In these three tables, you can find one common named column as record-id, This column is not going to be used on linking with other table, This column need to be populated by the system and not by the user, further no duplication is permitted and its unique nature needs to be maintained, Hence, Record-Id-seq will be useful on populating these tables, No harm in using database
obJect sequence named record-id-seq in multiple tables, Further Ledger-code, Voucher-number columns in
varied tables will also require sequence number but will be used with concatenation like VOU-0001, BS-0002-00 in CHAR column, At present, we require three sequences as record-id-Seq, voucher-seq, Ledger-seq, We will make an attempt to create these three sequences
Through obJect Browser Through sql command
101