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.

Now we shall see the tables we have created, l, Table Name: raak-ledger-master

Column-name Data Type 1 Width

Record-id Number Ledger-code char(l0) Ledger-name varchar2(200) Report-type char(2)

2, Table Name : raak-trans-master Column-name Data Type 1 Width Record-id Number

voucher-type char(l) voucher-number char(l0) voucher-date date,

voucher-naration varchar2(400)

debit-total number(l6,2)

credit-total number(l6,2))

3, Table Name : raak-trans-detail

Column-name Data Type 1 Width

l00