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.

 

 

run and 'table created' display will be in the result window. Likewise the other three tables can be created.

 

 

Apex Home SQL Workshop → SQL Commands

 

Window

 

Type

 

Create table raak-ledger-master (

 

record-id number, ledger-code char (10), ledger-name varchar2(200),

report-type char(2))                    CLICK RUN

 

 

 

In the result Window, Table created Message will get displayed.

Apex Home SQL Workshop → SQL Commands

 

Window

 

create Table raak-trans-master

 

( Record-id    number, voucher-type char(1), voucher-number char(10), voucher-date date,

voucher-naration varchar2(400),