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.

 

 

 

35-HOW TO CREATE TABULAR-FORM

Login oracle Apex using learner1learner

 

=> Application Builder

 

application

 

click Page 5

 

goto Page Rendering

 

goto Region section

 

click create button (Plus symbol)

 

→ select Form Region click Next

 

→ Click Tabular Form (create a data entry form based on option) → Click NEXT

Under Identify table 1 view owner

 

allow the defaults

 

"learner" against table I view owner

 

"insert, update and delete" against allowed operations click NEXT

 

Select the RAAK-LEDGER-MASTER and click NEXT

 

→ Under Identify columns to display

 

→ select all columns and click NEXT

 

Leave the default Primary key as RECORD-id and click NExT

 

→ select the existing trigger and click NEXT

 

→ select all the updatable columns and click Next

 

Under Page and Region attributes

 

Leave the Page No 5

 

Type LEDGER-MASTER against Page Name