Creating the Initial Application

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

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 begins 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, accept the default, Create Application, and click Next.

5. 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.

6. 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.

7. 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 - Select Classic.

   6. Include Analysis Pages - Leave blank.

      If selected, you are prompted for information about additional summary reports and charts you can add to this page.

   7. 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.

   8. Click the OEHR_DEPARTMENTS link.

   9. Under Page Definition, change the Page Name to Departments.

   10. Click Apply Changes.

   11. In the Create Application section, click Next.

   After adding your initial pages, define some application-level settings.

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

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

10. For Attributes, accept all the defaults and click Next.

    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.

11. For User Interface, select Theme 18 and click Next.

12. 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 list instead of as icons, from the View list select Details and click Go. 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.

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.