||Oracle Database Tips by Donald Burleson
Tabular Forms with APEX
A tabular form enables the editing of multiple
records of a table or view all at once. Submitting the form will then
perform updates or deletes on all the modified rows in the tabular
form. Editing lookup tables is an excellent use for Tabular Forms.
This exercise will create a tabular form on the
CONFERENCE_RSVP table. The
COMPANY column will purposely be left out again so it can be added in
a different section.
To create the tabular form, navigate to the Easy HTML DB Book
application's home page and click the Create Page button.
Choose the Form option and click Next.
Choose the Tabular Form option and click Next.
On the Table / View Owner page:
Table / View Owner: EASYHDB.
Allowed Operations: Allow all, UPDATE, INSERT and
On the Table/View Name page type in CONFERENCE_RSVP or select
it using the popup from the icon.
Then click Next.
On the Displayed Columns page:
Select all columns except for the
ID and COMPANY columns. The
COMPANY column will be added later in another exercise. In this case,
displaying the ID column is not desirable since it is the primary key
The ID and
COMPANY columns can be deselected by holding down the Control key and
clicking on them.
On the Primary Key page:
Primary Key: ID
There are only
two selections. The form wizards used Automatic Row processes that
only support the use of two column primary keys, so two columns can be
chosen here. Tables that have more that two column primary keys would
require custom programming and advanced use of the APEX API. That
explanation is beyond the scope of the book.
On the Primary Key Source page:
Choose the Existing trigger option.
On the Updateable Columns page select all columns and click
To keep a column from being editable in
the Tabular Form, it would be de-selected here.
On the Page and Region Attributes page:
Page Name: Tabular Form - CONFERENCE_RSVP.
Region Title: Conference Attendees.
Region Template: Leave the default of Report Region.
Report Template: Leave the default of template:
No tabs and click Next.
On the Button Labels page leave the defaults and click Next.
On the Branching page leave the defaults and click Next.
Finally, click Finish then Run the page.
Figure 8.13 shows the completed page as it is
now. Later, the COMPANY
column will be added.
The above book excerpt is from:
Oracle Application Express
Dynamic Web Pages with OAE
Michael Cunningham & Kent Crotty