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.

 

 

debit-total number(16,2),

 

credit-total number(16,2))          CLICK RUN

 

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

Apex Home SQL Workshop → SQL Commands

 

Window

 

create Table raak-trans-detail ( Record-id    number, voucher-number char(1O), ledger-cod char(1O),

voucher-naration varchar2(4OO), debit number(16,2),

credit number(16,2))           CLICK RUN

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

 

 

 

The following table creation scripts and the procedure need to be executed before creation of report page. The proposed Balance-sheet, profit-loss  table is temporary table  wherein the  data's will be  pooled  as required through some procedure before print 1 display. Generally,