Databases Reference
In-Depth Information
Figure 6-1.
APEX Form Wizard options
The following are some of the form types that you can create using the wizards listed in Figure
6-1
:
•
Form on a Procedure
: A form based on the arguments of a procedure, typically to collect values
for passing in to a procedure for subsequent processing
•
Form on a Table or View
: A form built on the columns of a table or view, having one item for
each table column and processing a single row of data at a time
•
Form on a Table with Report
: A form built on the columns of a table or view, having one item
for each table column and processing a single row of data at a time, plus a report on the
contents of the table or view, with navigational elements between the report and form pages
•
Master Detail Form
: A form on a pair of tables having a master-detail relationship. The APEX
Master-Detail Form Wizard creates all the data, processing, and navigational elements
required for managing master-detail data
•
Tabular Form
: A multirow, multicolumn form (like a spreadsheet) that allows editing of
multiple rows and columns of data at once
•
Form on a SQL Query
: A form built on the results of a SQL query. This is a very powerful form
construct due to its flexibility
•
Summary Page
: A display-only form showing selected items from an existing input form page.
A summary page is often used in building a confirmation page for a wizard
•
Form on Web Service
: A form on the arguments of a web service
•
Form and Report on Web Service
: A single-row form on the arguments of a web service with
a corresponding report of all rows of data, including navigational elements for moving from
report to form and back