|
Oracle® HTML DB
Release 2.0 |
|
 Previous |
 Next |
An application is a collection of pages which share a common session state and authentication. You create a new application in Oracle HTML DB using a wizard. You delete an application from the Application Builder home page.
Topics:
When you click Create on the Application Builder home page, you must choose one of the following options:
Create Application. Creates an application based on SQL queries or database tables. You can define blank pages or pages that contain reports, forms, tabular forms, or a report with a linked form. See "About the Create Application Wizard".
Create Application from Spreadsheet. Creates an application based on spreadsheet data. You can upload or paste spreadsheet data to create a table and then add a user interface. In the resulting application, users can create queries, add, insert, or update records, or analyze the data. See "About the Create Application from Spreadsheet Wizard".
Demonstration Application. Installs or uninstalls demonstration applications. Use demonstration applications to learn how to build applications. See "About Demonstration Applications".
|
See Also: "Adding Pages to an Application" for information about adding reports and forms by creating a new page |
The Create Application wizard enables you to create a fully functional application based on any number of tables. You can use the Create Application Wizard to create blank pages, or pages based on SQL queries or database tables. You can create SQL queries by manually typing SQL or by using the graphical user interface of Query Builder. Applications based on tables can consist of a simple report, a form and report, or a tabular form. When creating pages on tables, you have the option to generate analysis pages. Analysis pages extend a simple report or a report on a form to include multiple drilldown reports and charts.
Topics:
You can create an application based on a table, query, or drill-down query by selecting Create Application in the Create Application Wizard.
To create an application based on a table, query, or drill-down query:
Click the Application Builder icon on the Workspace home page.
Click the Create button.
Select Create Application and click Next.
Enter the basic application details and click Next:
Name - Enter a name to identify the application.
Application - Enter an unique integer value to identify the application.
Create Application - Select a creation method:
From scratch enables you to add pages manually
Based on existing application model enables you to copy page definitions from a previous application model.
Note that you will still have to define all other application attributes, or you can choose to copy some attributes using by choosing to copy shared components from another application (See step 7).
Schema - Your application will obtain its privileges by parsing all SQL as a specific database schema. Identify the database schema owner.
Note that the list of available schemas is limited to those associated with your workspace.
Next, add pages to your application.
Under Add Pages:
Select the type of page you want to add. Options include:
Blank creates a page with no built-in functionality.
Report creates a page the contains the formatted result of a SQL query. You can choose to build a report based on a table you select, or based on a custom SQL SELECT statement or a PL/SQL function returning a SQL SELECT statement that you provide.
Form creates a form to update a single row in a database table.
Tabular Form creates a form to perform update, insert, and delete operations on multiple rows in a database table.
Report and Form builds a two page report and form combination. On the first page, users select a row to update. On the second page users can add a new record or update or delete an existing record.
Action displays the currently selected page type. For each selection, the wizard prompts you for a variety of different types of information.
Report pages include the Include Analysis Pages check box. Select this option and follow the wizard prompts to extend a simple report or a report on a form to include multiple drilldown reports and charts.
Click Add Page.
The page (or pages) appear at the top of the page. To delete a page, click Delete icon.
Repeat the previous steps until all pages have been added.
Click Next.
Determine whether to include tabs in your application and click Next.
Determine whether to import shared components from another application. Shared components are common elements that can display or be applied on any page within an application.
To include shared components:
From Source Application, select the application from which you want to import shared components.
From Select Components to Import, select the components to import.
Click Next.
Select the following authentication and globalization preferences:
Default Authentication Scheme - Identify an authentication scheme you would like to use by default.
Authentication is the process of establishing users' identities before they can access an application.
Language - Select the primary language for this application.
This attribute identifies the language in which an application is developed. This language is the base language from which all translations are made.
User Language Preference Derived From - Specifies how the engine determines the application language. The application primary language can be static (that is, derived from the Web browser language) or determined from a user preference or item. The database language setting determines date display and sorting characteristics.
Click Next.
Select a theme and click Next.
Themes are collections of templates that can be used to define the layout and style of an entire application.
Confirm your selections. To return to a previous wizard page, click Previous. To accept your selections, click Finish.
The Create Application Wizard is designed with the assumption that the developer may run it multiple times. To facilitate this iterative approach to application development, every time you run the wizard it saves the page definitions to an application model.
Consider the following example. You create a new application by running the Create Application Wizard. After viewing the application, you realize it is not quite what you wanted. Instead of altering it, you can run the wizard again and select an application model. By selecting an existing application model when you rerun the wizard, you can quickly improve your application with minimal time and effort.
Another way to increase your productivity when creating an application is to specify user interface defaults. User interface defaults are metadata that enable you to assign default user interface properties to a table, column, or view within a specified schema.
You can increase your productivity when creating applications by leveraging application models and user interface defaults. Consider the following scenario:
Create an application based on tables or views by running the Create Application Wizard.
Run the generated application. Note any functional deficiencies.
Evaluate whether to create or edit user interface defaults.
For example, you can use user interface defaults to control how form field or report labels display. You can also utilize user interface defaults to display specific columns or have columns display in an alternate order.
Navigate to the Application home page and create a new application by clicking Create.
Select Create Application.
When prompted to enter application details, specify the following:
Name - Enter a name to identify the application.
Application - Enter an unique integer value to identify the application or accepts the default.
Create Application - Select Based on existing application model.
Select an application model.
Note the pages you previously created already appear.
Add pages, edit pages, or remove pages.
Complete the wizard.
Repeat steps 2 through 9 until the application meets your functional requirements.
You can create an application based on spreadsheet data by selecting Create Application from Spreadsheet in the Create Application Wizard.
To create an application from spreadsheet data:
Click the Application Builder icon on the Workspace home page.
Click the Create button.
Select Create Application from Spreadsheet.
Specify how spreadsheet data will be uploaded and click Next. Options include:
Upload file (comma-delimited or tab-delimited)
Copy and paste (up to 30KB)
Review the preview of how your table will display and click Next. You can modify the table name, change the column names or data types, or specify which columns to include.
Review the displayed Singular Name and enter a Plural Name.
Column User Interface Defaults display default label names.
(Optional) Under Column User Interface Defaults, edit the displayed Label names and click Next.
For Summary By Column, select the columns for which data will be summarized in reports and charts and click Next.
This wizard creates several summary reports. Select columns for which values will be aggregated in summary reports.
Aggregate by Column - Choose one or more columns for which you want data summarized or averaged.
Aggregate Function to Use - Select the aggregate function to use in the report (Sum or Average).
Click Next.
Select Application Options:
Application Name - Enter an alphanumeric name for this application.
Specify a Create Mode:
Read and Write includes insert and update pages.
Read Only does not include insert and update pages.
Select a chart type.
Click Next.
Select a theme and click Next.
Themes are collections of templates that can be used to define the layout and style of an entire application.
Confirm your selections. To return to a previous wizard page, click Previous. To accept your selections, click Create.
Oracle HTML DB installs with a number of demonstration applications. Use these applications to learn more about the different types of functionality you can include in your applications.
To access demonstration applications:
Click the Application Builder icon on the Workspace home page.
Click the Create button.
Select Demonstration Application.
The Demonstration Applications page appears, displaying links to the following applications:
To install a demonstration application, scroll down to the application you want to install, click Install.
Installed appears as the Status.
To edit an installed demonstration application, click Edit.
To run an installed demonstration application, click Run.
To reinstall a demonstration application, click Re-Install.
You can delete an application from within Application Builder, or while editing application attributes. If you delete an application you also delete all defined components (reports, charts, or forms), page controls (buttons, items, list of values), and shared components (breadcrumbs, lists, and tabs, but not user interface defaults).
Topics:
To delete an application from Application Builder:
Navigate to the Workspace home page.
Click the Application Builder icon.
Select an application.
When Application Builder appears, verify the application ID and name at the top of the page.
From the Tasks list, select Delete this Application.
Follow the on-screen instructions.
To delete an application from Edit Application Attributes:
Navigate to the Workspace home page.
Click the Application Builder icon.
Select an application.
Click Edit Attributes.
Click Edit Standard Attributes.
Verify the application ID and name.
Click Delete at the top of the page.