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.

filled with PopUP LOV (named LOV)

 

→      Element Width may be fixed as 50

 

→      Under List of Values section Named LOV column may be filled as

 

LOV-LEDGER-NAMES    click applycHANGES and RUN

 

 

 

 

 

( c )    debit column decimal precision should be 2 with comma format'

 

In the section Region Raak_Master_Detail Report will be   available.

 

Click report

 

→      Under column attributes section, click edit icon of debit

 

→      Under column Definition

 

→      say yes to compute sum

 

→      Heading alignment as right

 

→      column alignment as right

 

→      Under column Formatting

 

→      Number format as 99G99G990D00

 

 

 

( d )    Credit column decimal precision should be 2 with comma format'

 

In the section Region Raak_Master_Detail Report will be

 

available' Click report

 

→      Under column attributes section, click edit icon of debit

 

→      Under column Definition

 

→      say yes to compute sum

 

→      Heading alignment as right

 

→      column alignment as right