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:

1. On the Workspace home page, click the Application Builder icon.

2. Select an application.

3. Click Create Page.

4. Select Form and click Next.

5. Select Tabular Form and click Next.

   The Tabular Form Wizard appears.

6. For 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).

   3. Click Next.

7. For Table/View Name, select a table and click Next.

8. For Displayed Columns:

   1. Select the columns (updatable and nonupdatable) to include in the form.

      Note that you can modify the column order or your SQL query after you create the page.

   2. Click Next.

9. For Primary Key, select the Primary Key column and a secondary Primary Key column (if applicable) and click Next.

10. For Primary Key Source, select a source type for the primary key column and click Next. 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 if you wish to pick the sequence from a list of sequences available in the selected schema.

11. On Updatable Columns, select which columns should be updatable and click Next.

12. On Page and Region Attributes:

    1. Specify page and region information.

    2. Select a region template.

    3. Select a report template.

    4. Click Next.

13. On Tab, specify a tab implementation for this page and click Next.

14. On Button Labels, enter the display text to appear for each button and click Next.

15. On Branching, specify the pages to branch to after the user clicks the Submit and Cancel buttons and click Next.

16. Click Finish.