
The report works by collapsing the table columns into a stacked presentation that looks like blocks of label and data pairs for each row. Table 6-2 Create Application Wizard - Supported Page Types for Mobile Applications Page TypeĬreates a responsive report for mobile applications. You choose the tables on which to build the master and detail regions.Ĭreates a page with a chart to represent the result of a SQL query. With this page, users can query, insert, update, and delete values from two tables or views which are related. You choose a table on which to build the interactive grid.Ĭreates single page master detail with editable interactive grids.
#A label wizard enables you to create plus
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 form.Īn interactive grid presents users a set of data in a searchable, customizable report.
#A label wizard enables you to create update
On the second page, users can add a record, or update or delete an existing record.Ĭreates a form to update a single row in a database table. 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. 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). 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. Table 6-1 Create Application Wizard - Supported Page Types for Desktop Applications Page TypeĬreates a page with no built-in functionality.Ĭreates a page that contains the formatted result of a SQL query. When you exit the wizard, the application you create uses the values you specified as defaults. Setting these defaults enables you to exit the wizard without paging through each step.

You can create SQL queries by manually typing SQL, or by using the graphical user interface of Query Builder.Īt the workspace level, you have the option of setting defaults that are used for applications built in that workspace. Applications based on tables can consist of a simple report, a form and report, or an editable interactive grid. 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. After you create an application using this wizard, you can modify pages and add additional pages using the Create Page Wizard. By using the Create Application Wizard, you can create a complete application containing multiple pages including a variety of different reports and forms. The Create Application Wizard enables developers to design and quickly create basic Oracle Application Express applications.
