Oracle Tips by Burleson

Examining the Results of the APEX Form Wizard

The Form Wizard creates several page components which warrant some explanation.  Figure 8.3 shows the Page Rendering region for the new application page.

§         Regions:  In the regions section, it is apparent that an HTML region has been created to contain the buttons and page items.

§         Buttons:  Four buttons were created by the wizard.  The cancel button is a simple redirect, which means it will not execute page processes.  The other three buttons, Delete, Save, and Create are used to issue specific database manipulation requests.  Buttons will be explained in more detail later in the Examining Buttons section.

§         Page Items:  These, of course, are the page items to display the data.  The one exception is the P12_ID hidden page item.  This is not displayed but is used as a variable on the page.  The page item attributes are set up to participate in dynamic SQL with the Automatic Row processing processes.  This will be covered in the section Adding a Page Item to a Form.

Processes:  An Automatic Row Fetch process was also created.  This process dynamically builds SQL Select statements and populates page items.  The Automatic Row Fetch is explained in detail in the section on Examining Automatic Row Fetch.

The above book excerpt is from:

Easy HTML-DB Oracle Application Express

Create Dynamic Web Pages with OAE

ISBN 0-9761573-1-4   

Michael Cunningham & Kent Crotty

http://www.rampant-books.com/book_2005_2_html_db.htm