The Create Application Wizard enables you to build a complete application containing multiple pages. This section explains how the Create Application Wizard works and describes the types of pages you can create when running it.
See Also:
"Managing User Interface Design," "Creating a Database Application," and "Creating Mobile Applications"The Create Application Wizard enables you 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 reports, interactive reports, forms, tabular forms, and master detail 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 a tabular form. 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:
"Available Page Types When Running the Create Application Wizard," "About Adding Pages to a Database Application," "Building Queries with Query Builder" in Oracle Application Express SQL Workshop Guide and "Leveraging Application Builder Defaults" in Oracle Application Express Administration GuideThe User Interface you select when running the Create Application Wizard determines the available page types. Table 7-1, "Create Application Wizard - Available Page Types" lists the different types of pages you can create when running the Create Application Wizard. Not all page types are supported by all user interfaces.
Table 7-1 Create Application Wizard - Available Page Types
| Page Type | Description | Desktop | jQuery Mobile Smartphone |
|---|---|---|---|
|
Creates a page with no built-in functionality. |
Available |
Available |
|
|
Creates a page with a chart to represent the result of a SQL query. See Also: "Creating Charts" |
Available |
Available |
|
|
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 Also: "Developing Reports" |
Not available |
Available |
|
|
Creates a form to update a single row in a database table. You choose a table on which to build the form. See Also: "Developing Forms" |
Available |
Available |
|
|
Creates a responsive report for mobile applications. The reflow table 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 Also: "Developing Reports" |
Not available |
Available |
|
|
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 Also: "Developing Reports" |
Not available |
Available |
|
|
Creates a form that displays a master row and multiple detail rows within a single HTML form. With this form, users can query, insert, update, and delete values from two tables or views. You choose the tables on which to build the master report and detail form. See Also: "Managing Master Detail Forms" |
Available |
Not available |
|
|
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 Also: "Developing Reports" |
Not available |
Available |
|
|
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 implementation (Interactive or Classic). See Also: "Developing Reports" |
Available |
Not available |
|
|
You choose a table on which to build a two page report and form combination. You then choose the report implementation (Interactive or Classic). 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 Also: "Developing Reports" |
Available |
Not available |
|
|
Creates a form to perform update, insert, and delete operations on multiple rows in a database table. You choose a table on which to build the form. See Also: "Managing Tabular Forms" |
Available |
Not available |