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.

click edit attributes left side of the column icon with

 

paper, pencil will be available'

 

→ select the tabular form element

 

→ Element width will have default value as 16 and   change it as 50

 

→ Under element attributes

 

style = background: RED; color:YELLOW;font-weight:BOLD;

 

click APPLYCHANGES and RUN.

 

( D ) REPORT-TYP must have select list option to restrict the entries

 

→ Edit Page 5

 

→ Under Page Rendering section region, select REPORT and click

 

→ Under Column Attributes

 

Against REPORT-TYPE aliases

 

click edit attributes left side of the column icon with

 

paper, pencil will be available'

 

→ select LIST OF VALUES

 

→ Under Named-LOV select LOV-LEDGER-TYPE

 

this has already been created by us click APPLYCHANGES

→ select Tabular Form Element

 

In display as column select

 

Select List (Named LOV )

 

click APPLYCHANGES and RUN