Creating the Initial Application

This first exercise guides you through creating your initial application. Using the Create Application Wizard, you create two pages and specify basic application functionality.

The pages created in this section include:

• Home - This page is the first page displayed when the application is run. This page contains a link to the Departments report.

• Departments - This page is an interactive report of all departments.

  There are two types of reports, interactive and classic. Interactive is the default when creating applications, converting forms and creating report regions. Interactive reports should be selected when you want to provide user customizations such as filters, sorting, compilation and so on. If you have limited need for this functionality, you are best served by using a classic report.

To create your initial application:

1. Log in to Oracle Application Express.

   For instructions, see "Logging In to the Hosted Demo Environment" or "Logging In to Your Local Instance".

2. On the Workspace home page, click Application Builder.

3. Click the Create button.

   The Create Application Wizard appears.

   Note that each page within a wizard displays the title of the wizard (for example, Create Application). Each wizard page also displays a series of blocks on the left, representing the sequence of steps. The highlighted block indicates the step you are performing.

   
   Description of the illustration bldap_wiz_steplst.gif
   
   

   To orient you, each step in these exercises generally begin with the block label. For example, the first step in the Create Application Wizard highlights the word Method. Therefore, the next step orients you by beginning with the words For Method.

4. For Method, select Database and click Next.

5. Accept the default, From Scratch, and click Next.

6. For Name:

   1. Name - Enter AnyCo Corp

   2. Application - accept the default ID. The system provides a unique ID for each application you create in this workspace.

   3. Create Application - Accept the default, From scratch.

   4. Schema - Select the schema that contains the objects for this tutorial (for example, TWODAYPLUS).

   5. Click Next.

   Next, add a page to your application.

7. For Pages, specify the following in the Add Page section:

   1. Select Page Type - Accept the default, Blank.

      
      

      Tip: Explanatory information for each option appears on the right side of the page. This page-level help appears throughout the application.

      
      

   2. Page Name - Enter Home.

   3. Click Add Page.

      The Home page is now listed in the top area. Also, note that the Add Page area appears so you can continue adding pages to your initial application.

   Next, add a report page on the OEHR_DEPARTMENTS table.

8. In the Add Page section, specify the following:

   1. Select Page Type - Select Report.

   2. Subordinate to Page - Select Home (1).

      This sets up the hierarchy among the pages in your application.

   3. Page Source - Accept the default, Table.

   4. Table Name - Select OEHR_DEPARTMENTS.

      The list shows all tables and views in the schema associated with the application.

   5. Implementation - Accept the default Interactive.

   6. Click Add Page.

      Notice that the pages listed in the Create Application section reflect the hierarchy of the pages in your application.

      Next, change the default page name, OEHR_DEPARTMENTS, to Departments.

9. Click the Oehr Departments link.

10. Under Page Definition, change the Page Name to Departments and click Apply Changes.

11. In the Create Application section, click Next.

    Next, define some application-level settings.

12. For Tabs, select No Tabs and click Next.

13. For Shared Components, accept the default, No, and click Next.

14. For Attributes, make these changes:

    1. Authentication Scheme - Accept the default, Application Express.

       Note that Application Express is the default Authentication Scheme. The authentication scheme option enables you to control users' access to the application using Application Express authentication or another type of authentication.

    2. Language - Accept the default, English (en)

    3. User Language Preference Derived From - Accept the default, Use Application Primary Language.

    4. Date Format - Click the up arrow and select 12-JAN-04.

    5. Click Next.

15. For User Interface, select Theme 2 and click Next.

16. For Confirm, verify the information and click Create.

    The two pages you created, Home and Departments, appear as icons by default.

    
    

    Note: To view the pages in a report instead of as icons, click the View Report icon. Your view setting is retained from session to session. Because these steps use the default setting, switch back to Icons view before continuing.

    
    

    Notice that Oracle Application Express adds a Login page automatically to your application.

    
    Description of the illustration bldap_cr_app.gif
    
    

Congratulations! You created your first application using Oracle Application Express. Next, preview the application to see the application the way it would appear to end users.