Use the Create Application Wizard to build a complete application containing multiple pages. How the Create Application Wizard works depends upon the type of pages your are creating.
Topics:
See Also:
"Managing User Interface Design," "Creating a Database Application," and "Creating Mobile Applications"
The Create Application Wizard enables developers to design and quickly create basic Oracle Application Express applications. By using the Create Application Wizard, you can create a complete application containing multiple pages including a variety of different reports and forms. After you create an application using this wizard, you can modify pages and add additional pages using the Create Page Wizard.
You can use the Create Application Wizard to create an application with just a blank page or pages based on SQL queries on existing database tables. Applications based on tables can consist of a simple report, a form and report, or an editable interactive grid. You can create SQL queries by manually typing SQL, or by using the graphical user interface of Query Builder.
At the workspace level, you have the option of setting defaults that are used for applications built in that workspace. Setting these defaults enables you to exit the wizard without paging through each step. When you exit the wizard, the application you create uses the values you specified as defaults.
See Also:
"Building Queries with Query Builder" in Oracle Application Express SQL Workshop Guide
"Leveraging App Builder Defaults" in Oracle Application Express Administration Guide
When you run the Create Application Wizard, you choose a target user interface. The user interface you select determines the available page types. Not all page types are supported by all user interfaces.
Supported Page Types for Desktop Applications
If you are creating a desktop application, the Create Application Wizard supports the following page types.
Table 6-1 Create Application Wizard - Supported Page Types for Desktop Applications
| Page Type | Description | To Learn More |
|---|---|---|
|
Blank |
Creates a page with no built-in functionality. |
Not applicable. |
|
Report |
Creates a page that contains the formatted result of a SQL query. You choose a table on which to build a report, or provide a custom SQL SELECT statement or a PL/SQL function returning a SQL SELECT statement. You then choose the report type (that is, interactive report, interactive grid, or classic report). |
See "Developing Reports" |
|
Report and Form |
You choose a table on which to build a two page report and form combination. You then choose the report type (that is, interactive report, interactive grid, or classic report).On the first page, users select a row to update. On the second page, users can add a record, or update or delete an existing record. |
See "Developing Reports" |
|
Form |
Creates a form to update a single row in a database table. You choose a table on which to build the form. |
See "Developing Forms" |
|
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. |
|
|
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. |
|
|
Chart |
Creates a page with a chart to represent the result of a SQL query. |
See "Creating Charts" |
Supported Page Types for Mobile Applications
If you are creating a mobile application, the Create Application Wizard supports the following page types.
Table 6-2 Create Application Wizard - Supported Page Types for Mobile Applications
| Page Type | Description | To Learn More |
|---|---|---|
|
Blank |
Creates a page with no built-in functionality. |
Not applicable. |
|
List View |
Creates a responsive report for mobile applications. The report works by collapsing the table columns into a stacked presentation that looks like blocks of label and data pairs for each row. This switch occurs when there is not enough space available to display the report horizontally. |
See "Developing Reports" |
|
Column Toggle Report |
Creates a responsive report for mobile applications. By default, column toggle reports are created with all columns set to the same priority. However, the developer can edit the report column attributes and rank columns by importance. Columns with a lesser priority display at narrower widths (for example, columns with priority 6 will be hidden first and columns with priority 1 will be hidden last.) The report includes a Columns button which enables end users to select which columns they want to view. |
See "Developing Reports" |
|
Reflow Report |
Creates a responsive report for mobile applications. When there is not enough space available to display the report horizontally, the report works by collapsing the table columns into a stacked presentation that looks like blocks of label and data pairs for each row. |
See "Developing Reports" |
|
List View and Form |
Optimized to display data and provide easy navigation on Smartphones. Builds a two page List view and form combination. On the first page, users select a row to update from the List View. On the second page, users can update the selected table or view. |
See "Developing Reports" |
|
Form |
Creates a form to update a single row in a database table. You choose a table on which to build the form. |
See "Developing Forms" |
|
Chart |
Creates a page with a chart to represent the result of a SQL query. |
See "Creating Charts" |