Creating a Tabular Form

A tabular form enables users to update multiple rows in a table. The Tabular Form Wizard creates a form to perform update, insert, and delete operations on multiple rows in a database table.

To create a tabular form:

On the Database Home Page, click the Application Builder icon.
Select an application.
Click Create Page.
Select Form.
Select Tabular Form.

The Tabular Form Wizard appears.
On Identify Table/View Owner:
1. Specify the table or view owner on which you want to base your tabular form.
2. Select the operations to be performed on the table (for example, Update, Insert and Delete).
On Identify Table/View Name, select a table.
On Identify Columns to Display:
1. Specify whether or not to use user interface defaults. Select Yes or No.
  
  User interface defaults enable you to assign default user interface properties to a table, column, or view within a specified schema.
2. Select the columns (updatable and nonupdatable) to include in the form.
  
  You can modify the column order or your SQL query after you create the page.
On Identify Primary Key, select the Primary Key column and a secondary Primary Key column (if applicable).
On Defaults for Primary and Foreign Keys, select a source type for the primary key column. Valid options include:
- Existing trigger - Select this option if a trigger is already defined for the table. You can also select this option if you plan on specifying the primary key column source later after completing the form.
- Custom PL/SQL function - Select this option if you wish to provide a PL/SQL function to generate returning key value.
- Existing sequence - Select this option is you wish to pick the sequence from a list of sequences available in the selected schema.
On Updatable Columns, select which columns should be updatable.
On Identify Page and Region Attributes.
1. Specify page and region information.
2. Select a region template.
3. Select a report template.
On Identify Tab, specify a tab implementation for this page.
On Button Labels, enter the display text to appear for each button.
On Identify Branching, specify the pages to branch to after the user clicks the Submit and Cancel buttons.
Click Finish.

Note:

Do not modify the select list of a SQL statement of a tabular form after it has been generated. Doing so can result in a checksum error when you alter data in the form.