Developers can create forms using a number of wizards including the Create Application Wizard, Create Page Wizard, and Create Region Wizard. Note that the available forms differ depending the selected application user interface (for example, Desktop or Mobile).
Tip:
In some wizards you select the table and in others you provide the SQL query. For assistance in writing the SQL query, click the Query Builder button. See "Using Query Builder" in Oracle Application Express SQL Workshop Guide.
Topics:
When you create an application, you choose a target user interface. The user interface you select determines the available forms.
Available Forms for Desktop Applications
If you are creating a desktop application, the Create Page Wizard supports the following forms.
Table 9-1 Create Page Wizard — Forms for Desktop Applications
Form Type | Description | To Learn More |
---|---|---|
Report with Form on Table |
Creates two pages. One page displays as an interactive grid. Each row provides a link to the second page to enable users to update each record. You can select the table on which to build the report and form. Note: This wizard does not support tables having more than 127 columns. Selecting more than 127 columns generates an error. |
Not applicable. |
Editable Interactive Grid |
An interactive grid presents users a set of data in a searchable, customizable report. In an editable interactive grid, users can also add to, modify, and refresh the data set directly on the page. Functionally, an interactive grid includes most customization capabilities available in interactive reports plus the ability to rearrange the report interactively using the mouse. You choose a table on which to build the interactive grid. |
See "Managing Interactive Grids"and "Making an Existing Interactive Grid Editable" |
Single Page Master Detail |
Creates single page master detail with editable interactive grids. With this page, users can query, insert, update, and delete values from two tables or views which are related. You choose the tables on which to build the master and detail regions. |
|
Two Page Master Detail |
A two page master detail creates one interactive grid on the first page for the master table and on the second page it creates a standard form (for the master) and interactive grid for the detail. |
|
Form on a Table |
Creates a form that enables users to update a single row in a database table. You can choose a table on which to build a form. |
Not applicable. |
Form on a Procedure |
Builds a form based on stored procedure arguments. Use this approach when you have implemented logic or Data Manipulation Language (DML) in a stored procedure or package. |
Not applicable. |
Form on a SQL Query |
Creates a form based on the columns returned by a SQL query such as an |
Not applicable. |
Form on Web Service |
Creates a page with items based on a Web service definition. This wizard creates a user input form, a process to call the Web service, and a submit button. |
|
Report and Form on Web Service |
Creates a page with items based on a Web service definition. This wizard creates a user input form, a process to call the Web service, a submit button, and displays the results returned in a report. |
Available Forms for Mobile Applications
If you are creating a mobile application, the Create Page Wizard supports the following forms.
Table 9-2 Create Page Wizard — Forms for Mobile Applications
See Also:
The easiest way to create a form is to use the Create Page Wizard.
To create a form using the Create Page Wizard:
Use the Create Application Wizard to create a form to update a single row in a table. This wizard enables you to choose the table on which to build the form.
To create a form using the Create Application Wizard:
See Also:
Note:
You can also create a form manually by selecting it in the Gallery and dragging and dropping it in the Layout tab. However, Oracle does not recommend a manual approach when creating forms since it does not create all the necessary underlying form items and processes.
To create a form in Page Designer: