Skip Headers
Oracle® Database Application Express User's Guide
Release 3.0

Part Number B32258-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

2 Running a Demonstration Application

This section describes how to run the two demonstration applications provided with Oracle Application Express. It also explains how to modify the demonstration application called Sample Application that installs with Application Builder. Running and analyzing how an application works is an effective way to better understand how you can use Application Builder to build your own applications.

This section contains the following topics:

See Also:

"Next Steps" in Oracle Database 2 Day + Application Express Developer's Guide to learn more about other resources to expand your knowledge of Oracle Application Express

Installing a Demonstration Application

Application Builder includes two demonstration applications you can install. Use these applications to learn more about the different types of functionality you can include in your applications.

To install the demonstration applications:

  1. From the Workspace home page, click the down arrow on the right side of the Application Builder icon.

  2. From the menu, select Demonstrations.

    Description of new_menu.gif follows
    Description of the illustration new_menu.gif

    The Demonstration Applications page appears, displaying the following applications:

    • Sample Application offers a working demonstration that highlights basic design concepts.

    • Collection Showcase demonstrates shopping cart concepts.

  3. To install a demonstration application, locate the application you want to install, and click Install.

  4. Follow the on-screen instructions.

    The Application home page appears.

  5. To run an installed demonstration application, click the Run Application icon.

  6. Enter the appropriate login credentials and click Login.

    • For Sample Application:

      • For User Name, enter either demo or admin.

      • For Password, enter the current workspace name in lowercase letters.

    • For other demonstration applications, enter your workspace user name and password.

Note:

You can also access the Demonstration Applications page by clicking Create on the Application home page and then selecting Demonstration Application.

Running an Installed Demonstration Application

Once you have installed a demonstration application, you can run it from the Demonstration Applications page or from the Application Builder home page.

Topics in this section include:

Running an Application from Demonstration Applications

To run a demonstration application from the Demonstration Applications page:

  1. From the Workspace home page, click the down arrow on the right side of the Application Builder icon.

  2. From the menu, select Demonstrations.

    The Demonstration Applications page appears.

  3. On the Demonstration Applications page, locate the application you want to run.

  4. In the Action column, click Run.

  5. Enter the appropriate login credentials and click Login.

    • For Sample Application:

      • For User Name, enter either demo or admin.

      • For Password, enter the current workspace name in lowercase letters.

    • For other demonstration applications, enter your workspace user name and password.

Running an Application from the Application Home Page

Once you have installed a demonstration application, you can run it from the Application Builder home page.

To run a demonstration application from the Application Builder home page:

  1. Log in to the Workspace home page.

  2. Click the Application Builder icon.

  3. Click the application to be run.

    The Application home page appears.

  4. Click the Run Application icon.

  5. Enter the appropriate login credentials and click Login.

    • For Sample Application:

      • For User Name, enter either demo or admin.

      • For Password, enter the current workspace name in lowercase letters.

    • For other demonstration applications, enter your workspace user name and password.

Understanding Sample Application

This section describes the demonstration application called Sample Application.

Sample Application shows an easy-to-use interface for viewing, updating, and searching order and customer information for electronic and computer products. Users can navigate among the pages using the Home, Customers, Products, Orders, and Charts tabs.

Description of sampl_app_plain.gif follows
Description of the illustration sampl_app_plain.gif

Sample Application demonstrates the following functionality:

The following sections describe specific functionality available on each page.

About the Home Page

The Home page contains four regions:

  • My Quota

  • My Top Orders

  • Sample Application

  • Tasks

My Quota demonstrates the use of a Flash Dial Chart. This chart displays a value based on an underlying SQL statement.

Although not demonstrated in this example, you can enable an asynchronous refresh by editing the attributes of any SVG or Flash chart.

My Top Orders is a simple report based on a SQL query. This report displays a subset of the information that appears on the Orders page. Users can link to order details by selecting the Edit icon.

Sample Application is a simple HTML region that displays static text. You can create this type of region to display explanatory information to users.

Tasks contains a list with links to other pages within the application. Links available on the Home page Tasks list include:

  • About this Application links to an informational page that describes this application.

  • Enter a New Order links to a wizard for creating a new order.

  • Add a New Customer links to a form for entering new customer information.

  • Add a New Product links to a form for adding new products.

About the Customers Page

The Customers page enables users to view and edit customer information. The Customers page consists of two main regions:

  • Customers

  • Top Customers

Description of customer.gif follows
Description of the illustration customer.gif

Customers is an updatable report for tracking customer information. This region is also based on a SQL query. To search for a customer, enter a customer name in the Search field and click Go. To sort by customer name, click the column heading. A Sort icon then appears to the right of the heading Customer Name. To update existing customer information, click the Edit icon.

Top Customers ranks customers by order amount. This report is based on a SQL query that returns top customers based on their orders.

About the Products Page

The Products page enables users to view and edit product information. The Products page consists of two main regions:

  • Products

  • Top 10 Products

Description of products.gif follows
Description of the illustration products.gif

Products displays an updatable report for tracking product information. This region is based on a SQL query that uses a custom function for displaying images stored in the database. To sort by product category, click the column heading. A Sort icon appears to the right of the heading. To edit a product description, click the Edit icon. To add a new product, click the Create Product button at the bottom of the page. Users can export the data in the Products report to a spreadsheet by clicking Export to Spreadsheet.

Top 10 Products is also a SQL report. This report outlines the top ten products based on quantities sold.

Description of products_top.gif follows
Description of the illustration products_top.gif

About the Orders Page

The Orders page enables users to view and edit customer orders. The Orders page contains two regions:

  • My Orders

  • Orders by Day

Description of orders.gif follows
Description of the illustration orders.gif

My Orders is a wizard report that summarizes the current orders in the system. To sort a column, click the column heading. A Sort icon then appears to the right of the column heading. To edit an existing order, click the Edit icon. To add a new order, click the Enter New Order button.

Orders by Day is a Calendar report. This report displays each order on the appropriate date in a calendar. Users can select a calendar entry to view order details.

About the Charts Page

The Charts page illustrates three types of Flash charts available in Application Builder: cluster bar, pie chart, and stacked bar. To view a chart, select it from the list on the left.

About the Admin Page

The Admin page displays only if you log in to Sample Application using the user name admin. Sample Application makes use of a custom authentication scheme that stores user names and obfuscated passwords in a table. The Manage Users page enables you to manage additional users.

Note that this custom authentication scheme does not use any user names or passwords associated with Oracle Application Express application developers.

Viewing Pages in Printer Friendly Mode

Clicking Print in the upper left corner of the page displays the current page in Printer Friendly mode. When in Printer Friendly mode, the Application Express engine displays all text within the HTML form fields as text.

To enable your application to display in Printer Friendly mode, you need to create and then specify a Print Mode Page Template on the Edit Definition page.

Modifying a Demonstration Application

Once you understand the type of functionality available in a demonstration application, the next step is to learn more about the construction of each page. An efficient way to speed up the learning process is to analyze and deconstruct the pages in the demonstration applications. If you happen to break something, you can quickly delete the demonstration application and install it again. See "Deleting an Application" and "Installing a Demonstration Application".

You edit existing pages in an application, add pages to an application, or create entirely new applications using Application Builder.

Topics in this section include:

About the Developer Toolbar

The Developer toolbar is a quick way to edit the current application, the current running page, create a new page, control, or component, view session state, or turn edit links on or off.

Description of d_toolbar_149.gif follows
Description of the illustration d_toolbar_149.gif

The Developer toolbar consists of the following links:

  • Home links you to the Workspace home page. See "About the Workspace Home Page".

  • Application links you to the Application home page. See "Application Builder Concepts".

  • Edit Page accesses the Page Definition for the current running page. See "About the Page Definition".

  • Create links to a wizard for creating a new page, region, page control (item, button, branch, computation, process, or validation), or a shared control (navigation bar icon, tab, list of values, list, or breadcrumb). See "Building an Application".

  • Session links you to session state information for the current page. See "Viewing Session State".

  • Activity links you to the Activity reports page. See "Activity Reports".

  • Debug toggles the page between Debug and No Debug mode. See "Accessing Debug Mode".

  • Show Edit Links toggles between Show Edit Links and Hide Edit Links. Clicking Show Edit Links displays a small orange icon next to each editable object on the page. Each icon is orange and contains a triangle with two rules beneath it. Clicking the link displays another window in which to edit the object.

Editing a Demonstration Application

There are two ways to edit a demonstration application:

  • From the Demonstration Applications page, click Edit next to the desired application.

  • If you are running an application, click Application on the Developer toolbar.

The Application home page appears. The application ID and application name display at the top of the page.

Description of bldr_hm_top.gif follows
Description of the illustration bldr_hm_top.gif

You can run the current application, edit supporting objects, create shared components, or export and import information by clicking one of the following:

The pages that make up the application appear on the Application home page. To access a specific page, simply click it. To search for a specific page, enter a case insensitive query for the page title or page number in the Page field and click Go.

Viewing Underlying Database Objects

The Application Express engine renders applications in real time based on data stored in database tables. You can view the database objects for any demonstration application in Object Browser, or by viewing the Application Database Object Dependencies report.

Topics in this section include:

Viewing the Database Object Dependencies Report

The Database Object Dependencies report identifies database objects referenced by the current application. Review this report to determine what objects to move when deploying an application.

To view the Database Object Dependencies report:

  1. Navigate to the Workspace home page.

  2. Click the Application Builder icon.

  3. Select an application.

    The Application home page appears.

  4. On the Tasks list, click Application Reports.

  5. Click Shared Components.

  6. Under Application, click Database Object Dependencies.

  7. Click Compute Dependencies.

  8. To view the components that reference a specific database object, select the Reference Count number.

Viewing Database Objects in Object Browser

To view the database objects in Object Browser:

  1. On the Workspace home page, click SQL Workshop and then Object Browser.

    Object Browser appears.

  2. Select an object type from the Object list in the upper left corner of the page. For example, to view tables, select Tables.

  3. To search for an object name, enter keywords in the search field beneath the Object list.

    A list of matching objects appears.

    Description of demo_obrws_srch.gif follows
    Description of the illustration demo_obrws_srch.gif

  4. To perform a specific task related to the selected object, select the appropriate task button.

    For example, to modify a column in the DEMO_CUSTOMERS table:

    1. From the Objects list, select Tables.

    2. From the Tables list, select DEMO_CUSTOMERS.

    3. Click Modify Column.

  5. To view additional object details, select a tab beneath the object name. For example, to view the data in the DEMO_CUSTOMERS table:

    1. From the Tables list, select DEMO_CUSTOMERS.

    2. Select the Data tab.

      A report appears that displays the data in the DEMO_CUSTOMERS table appears.

    Description of demo_data.gif follows
    Description of the illustration demo_data.gif

See Also:

"Managing Database Objects with Object Browser"