Voucher-narat ion
Varchar2 (400
)
Description about the transactions
Debit
Number( 16, 2)
Credit
Number( 16, 2)
Having designed the four tables, we will borrow or copy the SQL scripts for creating the tables
→ login Apex Home Page
→ SQL Workshop
→ SQL Command
Create Table raak-ctrl-master ( Record-id number,
Ledger-seq number (16, 0), Voucher-seq number (16, 0))
create is the key command word for creating any obJect in the database. Out of various obJects table is one obJect wherein the columns are defined with data type and width. Hence create table should be followed with << table-name >> and the columns to be included in this table should be embedded with parenthesis. On giving this script in the command window, sql statement will