Contents

Title and Copyright Information

Preface

Topic Overview

Audience

Documentation Accessibility

Related Documents

Conventions

1 Introducing Oracle Application Express

About Oracle Application Express

Understanding Oracle Application Express Architecture

About the Oracle Application Express Environment

About Workspaces

About Oracle Application Express User Roles

Overview of the Application You Build

2 Accessing Your Development Environment

Before You Begin

Accessing the Hosted Demo Environment

Logging In to the Hosted Demo Environment

Setting Up Your Own Local Environment

Logging In to Administration Services

Creating a Workspace

Logging In to Your Local Instance

Creating Additional User Accounts

3 Getting Started with Oracle Application Express

About the Workspace Home Page

What Is Application Builder?

Installing the Sample Objects

Downloading OEHR Sample Objects

Importing the OEHR Sample Objects

Viewing Your Database Objects

4 Building Your Application

About the Application You Build in This Tutorial

Creating the Initial Application

Previewing Your Application

Modifying the Departments Report

Run the Report to View Added Columns

Using an Interactive Report

Save Report Settings as the Default

Create a Filter

Change the Sort Order

Add a Controlled break

Display the Single Row View

Reset Report Settings

Adding an Employees Report and Form

Previewing the Pages

Editing the Employees Report

Create a Function

Add a Column

Previewing the Page

Changing the Column Format

Adding a Link on the Home Page to the Employees Report

Adding a Department Column to the Employees Reports

Add a Column

Display Column in the Report

Save Report Settings as the Default

Linking a Column Value to Another Page

Change Column Value to a Link

Run the Departments Report

Create a Highlight to Test Clear Interactive Report Command

Adding a Conditional Department Details Report

Creating the Report and Condition

Add a List of Values

Add an Item to Display List of Values

Add a Branch

Change Employees Report Query

Change Column Link on Department Report

Turning Off Pagination

Adding Your Company Name

Switching Themes to Change the User Interface

5 About Deploying Your Application

Overview of Deploying Your Application

Creating End Users

About Publishing the Application URL

6 About Globalization

About Language Identification and Rendering

Specifying the Method for Global Identification

7 Next Steps

Downloading Public Packaged Applications and Sample Code

Additional Resources

Index

Oracle® Database

2 Day + Application Express Developer's Guide

Release 3.2

E11946-01

July 2009

Oracle Database 2 Day + Application Express Developer's Guide, Release 3.2

E11946-01

Copyright © 2003, 2009, Oracle and/or its affiliates. All rights reserved.

Primary Authors:  Drue Baker, Anne Romano, Terri Jennings

Contributors:  Joel Kallman, Sharon Kennedy

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

This software is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications which may create a risk of personal injury. If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous applications.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

This software and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.

Preface

Oracle 2 Day + Application Express Developer's Guide introduces you to application development using Oracle Application Express. This guide shows you how to set up development environment or access a hosted demonstration environment to use with this guide. It then walks you through building an initial application, modifying it, and previewing it.

Through a series of exercises, you become familiar with the Oracle Application Express user interface, basic product functionality, and some underlying concepts that enable you to develop professional, fast, and secure applications.

This preface contains these topics:

Topic Overview

Audience

Documentation Accessibility

Related Documents

Conventions

Topic Overview

This document contains the following sections:

Title
Description

Introducing Oracle Application Express

Describes Oracle Application Express, its architecture and the environment for using the product. It also introduces you to some concepts and terms used in this guide.

Accessing Your Development Environment

Leads you through the steps to access a development environment for your use.

Getting Started with Oracle Application Express

Introduces you to areas of the user interface. It also leads you through installing the sample objects to use with this guide.

Building Your Application

Leads you through the steps for building an application, modifying it, and previewing it at different points during the development process.

About Deploying Your Application

Describes some basic information about deploying your application. It also leads you through the steps to create end users and to determine the URL of your application.

About Globalization

Describes some basic information about globalization. It also leads you through the steps to specify how the application determines global identification.

Next Steps

Describes additional resources to expand your knowledge of Oracle Application Express and boost your productivity.

Audience

Oracle 2 Day + Application Express Developer's Guide is intended for:

Workspace administrators who want to set up the Oracle Application Express development environment

Application developers who want to learn how to build database-centric Web applications using Oracle Application Express

To use this guide, you must have a general understanding of relational database concepts and the operating system environment under which Oracle Application Express is running.

Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible to all users, including users that are disabled. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at http://www.oracle.com/accessibility/.

Accessibility of Code Examples in Documentation

Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation

This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.

Deaf/Hard of Hearing Access to Oracle Support Services

To reach Oracle Support Services, use a telecommunications relay service (TRS) to call Oracle Support at 1.800.223.1711. An Oracle Support Services engineer will handle technical issues and provide customer support according to the Oracle service request process. Information about TRS is available at http://www.fcc.gov/cgb/consumerfacts/trs.html, and a list of phone numbers is available at http://www.fcc.gov/cgb/dro/trsphonebk.html.

Related Documents

For more information, see these Oracle resources:

Oracle Application Express Installation Guide

Oracle Application Express Release Notes

Oracle Application Express Application Builder User's Guide

Oracle Application Express Advanced Tutorials

Oracle Application Express SQL Workshop and Utilities Guide

Oracle Application Express API Reference

Oracle Application Express Migration Guide

Oracle Application Express Administration Guide

Oracle Database Concepts

Oracle Database Advanced Application Developer's Guide

Oracle Database Administrator's Guide

Oracle Database SQL Language Reference

SQL*Plus User's Guide and Reference

For additional documentation available on Oracle's Technology Network, visit the Oracle Application Express Web site located at

http://www.oracle.com/technology/products/database/application_express/

For additional application examples, visit the Oracle by Examples (OBEs) Application Express page, located on Oracle's Technology Network. The OBEs provide step-by-step examples with screenshots on how to perform various tasks within Application Express.

http://www.oracle.com/technology/products/database/application_express/html/obes.html

For information about Oracle error messages, see Oracle Database Error Messages. Oracle error message documentation is available only in HTML. If you have access to the Oracle Database Documentation Library, you can browse the error messages by range. Once you find the specific range, use your browser's "Find in Page" feature to locate the specific message. When connected to the Internet, you can search for a specific error message using the error message search feature of the Oracle online documentation.

Many books in the documentation set use the sample schemas of the seed database, which is installed by default when you install Oracle. See Oracle Database Sample Schemas for information about how these schemas were created, and how you can use them yourself.

Printed documentation is available for sale in the Oracle Store at

http://oraclestore.oracle.com/

To download free release notes, installation documentation, white papers, or other collateral, visit the Oracle Technology Network (OTN). You must register online before using OTN; registration is free and can be done at

http://www.oracle.com/technology/membership/

If you have a user name and password for OTN, then you can go directly to the documentation section of the OTN Web site at

http://www.oracle.com/technology/documentation/

Conventions

The following text conventions are used in this document:

Convention | Meaning
boldface | Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.
italic | Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.
monospace | Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.

1 Introducing Oracle Application Express

This section describes Oracle Application Express, its architecture, and the environment for using the product. It also introduces you to concepts and terms used in this guide when discussing Oracle Application Express.

This section contains the following topics:

About Oracle Application Express

Understanding Oracle Application Express Architecture

About the Oracle Application Express Environment

About Oracle Application Express User Roles

Overview of the Application You Build

About Oracle Application Express

Oracle Application Express is a rapid Web application development tool for the Oracle database. Using only a Web browser and limited programming experience, you can develop professional applications that are both fast and secure. Thanks to built-in features such as user interface themes, navigational controls, form handlers, and flexible reports, Oracle Application Express accelerates the application development process.

From the end user's perspective, the deployed applications require only a browser and access to an Oracle database running Application Express.

Note:

This guide describes only a subset of Application Express functionality. For a complete list of features, see "What is Application Express?" in Oracle Application Express Application Builder User's Guide.

Understanding Oracle Application Express Architecture

Oracle Application Express installs with your Oracle database and is comprised of data in tables and PL/SQL code.

Whether you run the Oracle Application Express development environment or an application you built using Oracle Application Express, the process is the same. Your browser sends a URL request that is translated into the appropriate Oracle Application Express PL/SQL call. After the database processes the PL/SQL, the results are relayed back to your browser as HTML. This cycle happens each time you request or submit a page.

The application session state is managed in the database tables within Oracle Application Express. It does not use a dedicated database connection. Instead, each request is made through a separate database session, consuming minimal CPU resources.

About Oracle HTTP Server (Apache) and the Embedded PL/SQL Gateway

The version of Oracle Database you use determines how the URL is translated:

Versions before Oracle Database 11.1 require Oracle HTTP Server (Apache) with mod_plsql. The following illustration shows that architecture.

Description of arch.gif follows
Description of the illustration arch.gif

With Oracle Database 11.1 or later or Oracle Database 10g Express Edition, you can remove Oracle HTTP Server (Apache) from the architecture and replace it with the embedded PL/SQL gateway. The following illustration shows the architecture using the embedded PL/SQL gateway.

Description of arch_epg.gif follows
Description of the illustration arch_epg.gif

The embedded PL/SQL gateway provides Oracle Database with a Web server and also the necessary infrastructure to create dynamic applications. The embedded PL/SQL gateway runs in the XML DB HTTP server in the Oracle database and includes the core features of mod_plsql, but does not require the Oracle HTTP Server powered by Apache. Inclusion of the embedded PL/SQL gateway simplifies the architecture and eliminates the middle tier.

About the Application Express Engine

The Application Express engine renders and processes pages. It also performs these tasks:

Session state management

Authentication services

Authorization services

Page flow control

Validations processing

About the Oracle Application Express Environment

Oracle Application Express enables a single Oracle database to become a shared workgroup database service. Multiple users can access it using a Web browser without installing additional software.

About Workspaces

The area where you develop applications is called a workspace. A workspace is a virtual private database that enables multiple users to work within the same Oracle Application Express installation while keeping their objects, data, and applications private.

In a typical development environment, you might create a single workspace for all your developers to share. However, you can also create dedicated workspaces for specific developers or projects. Creating a dedicated workspace limits access to the workspace objects to only those users associated with the workspace.

The following illustration shows the relationship among users and developers, workspaces, and database schemas.

Description of arch_multi2.gif follows
Description of the illustration arch_multi2.gif

When you create a workspace, you associate it with a new or existing schema. A schema is a logical container for database objects such as tables, views, and stored procedures. A single schema can be associated with one or more workspaces.

About Oracle Application Express User Roles

When setting up Application Express users at a large organization, you assign roles and privileges to specific users. The roles within Oracle Application Express include the following:

Workspace administrators are users who perform administrator tasks specific to a workspace such as managing user accounts, monitoring workspace activity, and viewing log files. For this guide, you are acting as the workspace administrator when setting up the development environment.

Developers are users who create and edit applications. Developers can have their own workspace or share a workspace.

End users have no development privileges. You define end users so that they can access applications that do not use an external authentication scheme.

Oracle Application Express administrators are superusers that manage an entire hosted instance using the Application Express Administration Services application.

The following illustration shows multiple users with various roles accessing the Oracle Application Express development environment, Application Express Administration Services, and the published applications.

Description of arch_diffroles2.gif follows
Description of the illustration arch_diffroles2.gif

For this guide, you must have the privileges usually associated with three roles: Application Express Administrator, Workspace Administrator, and Developer. The following illustration shows an Oracle Application Express instance with a single user.

Description of arch2_single.gif follows
Description of the illustration arch2_single.gif

Overview of the Application You Build

In "Building Your Application", you create a simple Human Resources (HR) application for a fictitious company called AnyCo Corp. The application manages departmental and employee information stored in the department and employees tables that you create. The tutorial shows you how to build the application, modify it, and then preview it.

2 Accessing Your Development Environment

This section guides you through the steps to access an Oracle Application Express development environment for your use. Then, you and other developers can begin building applications within Oracle Application Express.

This section contains the following topics:

Before You Begin

Accessing the Hosted Demo Environment

Setting Up Your Own Local Environment

Creating Additional User Accounts

Before You Begin

Before you begin this section, do the following:

Determine which environment you want to use:

Oracle provides a hosted demonstration (demo) environment where you can try out Oracle Application Express.

Using the demo environment is the fastest way to access a development environment. You request a workspace from an Oracle Application Express Web site and provide some basic user information. Shortly after you submit your request, you receive your login credentials in an email. This option does not require installing any software.

For instructions on getting started with the demo environment, see "Accessing the Hosted Demo Environment".

Note:

Do not use the hosted demonstration environment for your production work.

Set up your own local instance of Oracle Application Express. To do that, you install the product and then follow the steps in "Setting Up Your Own Local Environment".

For instructions on installing Oracle Application Express, review the installation guide for your operating environment. See "Related Documents".

Read "Introducing Oracle Application Express".

To view or develop Oracle Application Express applications, use a Web browser that supports JavaScript and the HTML 4.0 and Cascading Style Sheet (CSS) 1.0 standards. The following browsers meet this requirement:

Microsoft Internet Explorer 6.0 or later

Firefox 1.0 or later

Enable cookies for your Web browser.

Accessing the Hosted Demo Environment

To try out Oracle Application Express without installing the product locally, go to the hosted demo environment and sign up for a workspace.

To access the hosted demo environment:

In a Web browser, go to:

http://apex.oracle.com

Under the Login button, click Sign up for an account.

The Registration Wizard appears. Note the steps included in the wizard appear in a flowchart on the left side of the page. The highlighted block indicates the step you are performing.

On the Welcome page, review the information and click Next.

For Identify Administrator, enter valid information and click Next.

The system generates an email with your login credentials and sends it to the email address you enter.

For Workspace, enter a name for your workspace.

Workspace names must be unique. Requesting a duplicate name might delay your request. In general, enter a name that is significant to you. For example, enter your own name, your company name, or the name of the project or department to which your applications pertain.

To use the same name for your workspace and your schema (defined in the next step) use alphabetic characters when naming your workspace. Schema names are restricted to alphabetic characters.

For New or Existing Schema, select Request a new schema and click Next.

For Database Schema, do the following:

New schema to create - Enter a name containing only alphabetic characters.

Initial Space Allocation - Select at least 10 MB to accommodate the space needed for creating the objects required for this guide.

Click Next.

For Service Description, enter the requested information and click Next.

For Confirmation:

Enter the displayed numeric and alphabetic characters in the Verification Code field. Be sure to use the correct capitalization because the verification code is case-sensitive.

Description of setuphst1_vericode.gif follows
Description of the illustration setuphst1_vericode.gif

Review the information and click Submit Request.

An initial email containing a link is sent to you. Click the link to complete the workspace provisioning process. This step verifies that your email address is valid before approving a workspace. After that, an email with your login credentials is sent to you. Use those credentials to log in to the hosted demo environment and begin using Oracle Application Express.

Logging In to the Hosted Demo Environment

Using the login credentials you received in an email, log in to your dedicated workspace on the hosted demo environment.

To log in to the hosted demo environment:

In a Web browser, go to:

http://apex.oracle.com

On the Login page, enter your login credentials.

Click Login.

The Workspace home page appears. You might be prompted to change your password. If not, you can change it manually by clicking the Change Password link on the right side of the Workspace home page. Then, enter in the information requested on the page that appears.

To continue with the tutorials, skip the rest of this section and go to "Getting Started with Oracle Application Express".

Setting Up Your Own Local Environment

Instead of using the hosted demo environment, you can install Oracle Application Express locally. If you do a local installation, you must set up your development environment. The general steps you must perform include:

Log in to Application Express Administration Services, as described in "Logging In to Administration Services".

Create a workspace, as described in "Creating a Workspace".

(Optional) Create additional users with developer or administrator privileges, as described in "Creating Additional User Accounts".

Note:

This tutorial explains a simplified method for setting up your development environment so that you can begin using Oracle Application Express. However, when you want to set up your development environment to accommodate your real-life development needs, review "Oracle Application Express Hosted Instance Adminitration" in Oracle Application Express Administration Guide.

Logging In to Administration Services

To set up your local development environment, you first must log in to Oracle Application Express Administration Services. This is a separate application for managing an entire Oracle Application Express instance.

To log in to the Oracle Application Express Administration Services:

In a Web browser, go to the Oracle Application Express Administration Services application. Depending on which setup you are using, Oracle Application Express is installed to one of these locations:

If your setup uses the embedded PL/SQL gateway, go to:

http://hostname:port/apex/apex_admin

Where:

hostname is the name of the system where Oracle XML DB HTTP Server is installed.

port is the port number assigned to Oracle XML DB HTTP Server. In a default installation, this number is 8080.

apex is the database access descriptor (DAD) defined in the configuration file.

For users who have upgraded from earlier versions, or who have a custom configuration, this value may be htmldb or something else. Verify your DAD with your Oracle Application Express administrator.

See Also:

"Verifying the Oracle XML DB HTTP Server Port" in Oracle Application Express Application Builder User's Guide

If your setup uses the Oracle HTTP Server (Apache) with mod_plsql, go to:

http://hostname:port/pls/apex/apex_admin

Where:

hostname is the name of the system where Oracle HTTP Server is installed.

port is the port number assigned to Oracle HTTP Server. In a default installation, this number is 7777. You can find information about your Oracle HTTP Server installation's port number from either of the following files:

ORACLE_BASE\ORACLE_HOME\install\portlist.ini

ORACLE_BASE\ORACLE_HTTPSERVER_HOME\Apache\Apache\conf\httpd.conf

Be aware that if you change a port number, it is not updated in the portlist.ini file. You can only rely on this file immediately after installation.

pls is the indicator to use the mod_plsql cartridge.

apex is the database access descriptor (DAD) defined in the mod_plsql configuration file.

For users who have upgraded from earlier versions, or who have a custom configuration, this value may be htmldb or something else. Verify the DAD with your Oracle Application Express administrator.

See Also:

"Managing Oracle Database Port Numbers" in Oracle Application Express Installation Guide and ORACLE_BASE\ORACLE_HTTPSERVER_HOME\Apache\modplsql\conf\dads.readme for more information on database access descriptors

The Login page appears.

In Username, enter the username you specified when you installed Oracle Application Express.

In Password, enter the Oracle Application Express administrator account password you specified when you installed Oracle Application Express.

Click Login.

Oracle Application Express Administration Services appears.

Creating a Workspace

From Administration Services, create a workspace. A workspace is a shared work area within the Oracle Application Express development environment that has a unique ID and name. All users in the workspace can access all its applications and scripts. For more information about workspaces, see "About Workspaces".

To create a workspace:

Log in to Oracle Application Express Administration Services.

The Home page appears for Administration Services.

Description of adminsvc.gif follows
Description of the illustration adminsvc.gif

Click Manage Workspaces.

Under Manage Workspaces, click Create Workspace.

Description of setuphst1_crtwksp.gif follows
Description of the illustration setuphst1_crtwksp.gif

The Create Workspace Wizard appears.

For Identify Workspace, enter the following information:

Workspace Name - Enter a unique workspace name. This guide uses 2DayPlus for the workspace name.

In general, you want to enter a workspace name that is significant to you. For example, you might enter your own name, your company name, or the name of the project or department to which your application pertains.

If you want to use the same name for both your workspace and schema, enter a workspace name that contains only alphabetic characters. Schema names are restricted to alphabetic characters.

Description - Enter a workspace description.

Click Next.

Description of cr_wkpc1.gif follows
Description of the illustration cr_wkpc1.gif

For Identify Schema, enter the following information:

Re-use existing schema - Select No if you are creating your first workspace.

A schema is a logical container for database objects. In this step, you are creating the container for database objects you add later in this tutorial.

Schema Name - Enter a schema name. This guide uses TWODAYPLUS for the schema name.

You must use only alphabetic characters in your schema name.

Schema Password - Enter a case-sensitive password.

Space Quota (MB) - Select at least 10 MB to accommodate the necessary space for creating the objects required for this guide.

Click Next.

Description of cr_wkspc_schema.gif follows
Description of the illustration cr_wkspc_schema.gif

For Identify Administrator, enter the following information:

Administrator Username - Accept the default, ADMIN, or enter another user name to be used in Oracle Application Express.

You are creating an account for only one user, yourself as an administrator. To see instructions for creating additional users, see "Creating Additional User Accounts".

Administrator Password - Enter a case-sensitive password.

Enter the remaining information, including your valid email address, and click Next.

The login credentials for accessing Oracle Application Express are sent to the email address you enter here, if you have configured the email settings for your Oracle Application Express environment.

Description of cr_wkspc_admin.gif follows
Description of the illustration cr_wkspc_admin.gif

Confirm your selections and click Create.

Logging In to Your Local Instance

To log in to your local instance of Oracle Application Express, you must have this information:

URL where you can access Oracle Application Express

Workspace name you use to develop applications

Username set up for you for this workspace within Oracle Application Express

Password set up for you for this workspace within Oracle Application Express

If you set up your development environment, you have your login credentials. Otherwise, contact the person who created your user account to supply the information.

To log in to Oracle Application Express:

In a Web browser, go to the Oracle Application Express Login page. Depending on your setup, Oracle Application Express installs to one of these locations:

If your setup uses the embedded PL/SQL gateway:

http://hostname:port/apex

If your setup uses the Oracle HTTP Server (Apache) with mod_plsql:

http://hostname:port/pls/apex

For an explanation of the URLs, see "Logging In to Administration Services".

The Login page appears.

Under Login, enter your login credentials.

Description of login.gif follows
Description of the illustration login.gif

Click Login.

Creating Additional User Accounts

As an administrator, you inherit all the privileges associated with the developer role. If you want to start developing the application shown in this guide, skip this section and go to "Logging In to Your Local Instance".

However, you might want to create user accounts for other developers who share this workspace. Associating users with the workspace grants them access to all applications and scripts within that workspace. You can also create additional user accounts for workspace administrators.

To create user accounts:

Log in to the Workspace where you want to add users. See "Logging In to the Hosted Demo Environment" or "Logging In to Your Local Instance".

The Workspace home page appears.

From the Administration links list on the right, click Manage Application Express Users.

Under the Tasks list on the right, click either the Create Developer or Create Workspace Administrator link.

The Create User page appears.

Description of deploy_cr_enduser.gif follows
Description of the illustration deploy_cr_enduser.gif

Under Account Control:

Set Account Availability - Select Unlocked.

Require Change of Password On First Use - Select No if you do not want to force this user to change his or her password at first log in.

Under User Identification, enter the appropriate information:

User Name - Enter a user name for this end user.

Password and Confirm Password - Enter a case-sensitive password for this account.

Email Address - Enter the valid email address for this end user.

This email address must be valid so that users can receive the login credentials to log in to the application.

Under Developer Privileges:

Accessible Schemas (null for all) - Leave this blank to allow the end user to access all applications in the workspace, or enter a colon-delimited list of schemas to restrict the end user's access.

If a user does not have access to the schema that an application is built on, the user cannot access the application.

Default Schema - Accept the default, the schema you set up for this guide.

User is a developer - Accept the default.

User is a workspace administrator - Accept the default.

Under User Groups, you can select a user group.

You can use groups to restrict access to parts of an application. Groups are primarily useful when using Application Express Authentication.

Under Additional Attributes, you can enter additional user information.

Click Create User or Create and Create Another.

See also:

"Managing Application Express Users" in Oracle Application Express Administration Guide

3 Getting Started with Oracle Application Express

This section introduces you to areas of the Oracle Application Express user interface. It also shows you how to install the sample objects to use with this guide.

Before you begin, log in to either the host demo environment or your local instance of Oracle Application Express. For instructions, see "Accessing Your Development Environment".

This section contains the following topics:

About the Workspace Home Page

What Is Application Builder?

Installing the Sample Objects

About the Workspace Home Page

When you log in to Oracle Application Express, the Workspace home page appears.

Description of workspace4.gif follows
Description of the illustration workspace4.gif

Take a few minutes to explore the product. The following three large icons appear in the center of the page:

Application Builder. Use Application Builder to assemble an HTML interface (or application) on top of database objects such as tables and procedures. Most exercises in this guide use Application Builder.

SQL Workshop. Use the SQL Workshop to access tools to view and manage database objects. Click SQL Workshop to access the following database tools:

Object Browser. View, create, modify, browse, and drop database objects. Use the PL/SQL editor to edit and compile packages, procedures, functions, and triggers while taking advantage of error reporting.

SQL Commands. Run SQL commands and anonymous PL/SQL, scripts, and saved queries.

SQL Scripts. Create, edit, view, run, and delete script files. You can also upload and download scripts from your local file system.

Query Builder. Search and filter database objects, select objects and columns, create relationships between objects, view formatted query results, and save queries with little or no SQL knowledge, using Query Builder's graphical user interface.

Utilities. Import and export data from the database, generate DDL, view object reports, restore dropped database objects, and perform other tasks.

Note that your workspace and username appear in the lower left corner.

About the Administration List

An Administration list appears on the right side of the Workspace home page. Use the links to administer your application development environment.

If you have administrator or developer privileges, these links appear:

Administration. Click this link to view a list of administrative tasks. If you are a developer, you have limited access to these features.

Manage Services. Click this link to manage session state, log files, preferences, and application models.

Manage Application Express Users. Click this link to manage Application Express user accounts and user groups.

Monitor Activity. Click this link to monitor page view and application changes.

Change Password. Click this link to open a popup window where you can change your workspace password.

About Application Express. Click this link to see version and configuration information for both Oracle Application Express and your database.

About the Migrations Link

Use the Migrations link to migrate a Microsoft Access application and generate an Oracle Application Express application from the retrieved objects.

About the Workspace Schemas List

The Workspace Schemas list displays the database schemas that are associated with, and therefore accessible to, this workspace.

About the Links List

The Links list contains links to resources to expand your knowledge of Oracle Application Express.

Description of gtst_reslinks.gif follows
Description of the illustration gtst_reslinks.gif

Oracle Technology Network opens the Oracle Application Express section of Oracle Technology Network. Use this page to access additional information and resources about using Oracle Application Express.

Tip:

Use this link to check for newer versions of Oracle Application Express, to download packaged applications you can use with Oracle Application Express, and to take advantage of sample code to accelerate your development process. For more information, see "Next Steps".

Discussion Forum opens the Oracle Application Express Discussion Forum. This is an excellent resource for research and finding answers to questions or answering questions from other users.

User's Guide opens an HTML-based online Help system. You can also access online Help by clicking the Help link in the upper right corner of any page in Oracle Application Express.

What Is Application Builder?

You use the Application Builder component of Oracle Application Express to build your application. Through wizards or your direct input, you can assemble an HTML interface (or application) on top of database objects such as tables and procedures. Each application is a collection of linked pages using tabs, buttons, or hypertext links.

A page is the basic building block of an application. Pages also contain user interface elements such as tabs, lists, buttons, items, and regions. To see the definition of each page belonging to your application, you use the Page Definition page.

Description of gtst_pgdef1.gif follows
Description of the illustration gtst_pgdef1.gif

The Page Definition contains three main areas:

Page Rendering lists user interface controls and logic that are executed when a page is rendered. Page rendering is the process of generating a page from the database.

Page Processing lists logic controls (such as computations and processes) that are evaluated and executed when the page is processed.

Shared Components lists components used by the current page that can also be referenced by other pages within your application.

Installing the Sample Objects

In Oracle Application Express, users log in to a workspace. You can think of each workspace as a shared work area that separates your objects, data, and applications into a virtual private database.

Before performing any tasks in this guide, you must create the appropriate sample objects within your workspace. These sample objects are copies of the objects that are typically installed in two schemas:

Human Resources (HR)

The HR schema contains information about the employees and the facilities where they work. Each employee has an identification number, email address, job identification code, salary, and manager. Employees are assigned to a department, and each department is associated with one location that has a full address, including the street name, postal code, city, state or province, and country code.

Order Entry (OE)

The OE schema tracks product inventories and sales of a company's products, including the product identification number, the product name, the associated associates product category, product descriptions, the weight group (for shipping purposes), the warranty periods, the suppliers, the availability status, and a minimum price.

To create the objects locally in your workspace, import the OEHR Sample Objects application.

This section contains the following topics:

Downloading OEHR Sample Objects

Importing the OEHR Sample Objects

Viewing Your Database Objects

Tip:

In order to successfully import the objects associated with the OEHR Sample Objects application, your Oracle database must include Oracle Spatial. If your database instance does not include Oracle Spatial, you can install it using Database Configuration Assistant. To learn more, see the Oracle Application Express Installation Guide for your operating environment.

Downloading OEHR Sample Objects

To import the OEHR Sample Objects application, you must download it from the Oracle Technology Network (OTN).

To download the OEHR Sample Objects application from OTN:

In your Web browser, go to:

http://www.oracle.com/technology/products/database/application_express/

Click Packaged Applications.

Click OEHR Sample Objects.

Download and save the oehr_sample_objects.zip file to your computer.

Unzip and extract the oehr_sample_objects_installer.sql file:

Microsoft Windows - Double-click the oehr_sample_objects.zip file

UNIX or Linux - Enter the following command:

$ unzip oehr_sample_objects.zip

Importing the OEHR Sample Objects

After you download and unzip the OEHR Sample Objects application, import it into Oracle Application Express. During the import process, specify installation of both the application and the supporting objects. Installing the application creates the objects and sample data needed to complete the exercises in this guide.

To import and install the OEHR Sample Objects application:

Log in to Oracle Application Express.

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

On the Workspace home page, click Application Builder.

The Application Builder home page appears.

Click the Import button.

For Specify File, specify the following:

Import file - Click Browse and navigate to the oehr_sample_objects_installer.sql file.

File Type - Select Application, Page, or Component Export.

File Character Set - Select the correct character set.

Click Next.

Next, you must install the imported file.

To install an imported file, click Next.

The Install Application Wizard appears.

In the Install Application Wizard, specify the following:

Parsing Schema - Select the schema you created when you set up your development environment.

Build Status - Select Run and Build Application.

Install As Application - Select Auto Assign New Application ID.

Click Install.

For Install Supporting Objects, select Yes and click Next.

Confirm your selections by clicking Install.

After the installation is completed, click the Home breadcrumb link at the top of the page.

The Application Builder home page appears.

Checking Your Workspace Storage Space

If you experience problems installing the OEHR Sample Objects application, verify the available space in your workspace. If you do not have enough space, request additional storage space.

If you are a workspace administrator, you can:

Determine if you have enough storage space. See "Viewing the Workspace Overview Report" in Oracle Application Express Administration Guide.

Request additional storage space. See "Requesting Additional Storage" in Oracle Application Express Administration Guide.

Deleting the OEHR Sample Objects Application

Deleting the OEHR Sample Objects application and deinstalling the supporting objects completely removes all associated objects and sample data.

To delete the OEHR Sample Objects application:

Log in to Oracle Application Express.

On the Workspace home page, click Application Builder.

The Application Builder home page appears.

Click the OEHR Sample Objects icon.

On the Tasks list, click Delete this Application.

The Deinstall page appears.

To remove all associated objects and sample data, select Remove Application Definition and Deinstall Supporting Objects.

Click Deinstall.

Using HR Schema Instead of OEHR Sample Objects

If you are using a locally installed instance of Oracle Application Express release 2.2.1.1 or later (not a hosted demo environment such as http://apex.oracle.com) and have the HR schema installed, you can perform the exercises in this guide directly against the HR schema.

To do so, you must associate the HR schema with your workspace instead of performing the steps described in "Importing the OEHR Sample Objects".

Note:

The table names in the HR schema do not include the OEHR prefix (EMPLOYEES versus OEHR_EMPLOYEES). Because this guide outlines all the steps using the OEHR schema, you must adjust your selections and code accordingly.

Also, note that other users may be using the HR schema. Therefore, the objects or data within the objects may differ from that shown in this guide.

Viewing Your Database Objects

Review the objects you just created by going to Object Browser. Object Browser enables you to browse, create, and edit objects in your database.

To view the objects:

On the Workspace home page, click SQL Workshop.

Click Object Browser.

Object Browser appears.

Description of o_brws_oehr.gif follows
Description of the illustration o_brws_oehr.gif

Object Browser is divided into two sections:

Object Selection pane displays on the left side of the Object Browser page and lists database objects of a selected type within the current schema.

Detail pane displays to the right of the page and displays detailed information about a selected object.

From the list in the Object Selection pane on the left, select Tables.

The Detail pane lists the tables in your current schema.

In the Object Selection pane, click OEHR_EMPLOYEES from the list.

The Detail pane shows details about the table.

Click the Data tab at the top of the Details pane.

The data in the OEHR_EMPLOYEES table appears. Note that other tabs show additional details about the object you select.

To search for an object name, enter a case-insensitive term in the Search field.

Description of o_brws_srch_oehr.gif follows
Description of the illustration o_brws_srch_oehr.gif

To view all objects, leave the Search field blank.

See also:

"Managing Database Objects with Object Browser" in Oracle Application Express SQL Workshop and Utilities Guide

4 Building Your Application

In this tutorial, you create a Human Resources (HR) application for a fictitious company called AnyCo Corp. This section shows you how to build the application, modify it, and preview it at different points during the development process.

Before you begin this section:

Read "Getting Started with Oracle Application Express".

Ensure you have installed the database objects as described in "Installing the Sample Objects". This applies to both the hosted demo environment and local instance.

This section contains the following topics:

About the Application You Build in This Tutorial

Creating the Initial Application

Using an Interactive Report

Modifying the Departments Report

Adding an Employees Report and Form

Editing the Employees Report

Adding a Link on the Home Page to the Employees Report

Adding a Department Column to the Employees Reports

Linking a Column Value to Another Page

Adding a Conditional Department Details Report

Adding Your Company Name

Switching Themes to Change the User Interface

About the Application You Build in This Tutorial

This tutorial guides you through the development of a Human Resources (HR) application for a fictitious company called AnyCo Corp. The application enables users to view and modify employee information stored in the OEHR_DEPARTMENTS and OEHR_EMPLOYEES tables.

When building the application, you perform these tasks:

"Creating the Initial Application": Create an application that includes a Home page and a basic Departments report.

"Using an Interactive Report": Run and use the Interactive Report.

"Modifying the Departments Report": Expand the report to pull in data from other tables.

"Adding an Employees Report and Form": Build an Employee form and report based on the OEHR_EMPLOYEES table.

"Editing the Employees Report": Add calculated fields to the Employees report.

"Adding a Link on the Home Page to the Employees Report": Add a link on the Home page.

"Adding a Department Column to the Employees Reports": Modify the Employees report to enable the user to select a department.

"Linking a Column Value to Another Page": Add a link on the Departments report that navigates the user to the Employees report.

"Adding a Conditional Department Details Report": Add a report as a region that displays department details.

"Adding Your Company Name": Add your company name so that it appears on all pages in your application.

"Switching Themes to Change the User Interface": Switch the theme for your application.

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.

See also:

For more information on the difference between these two report types, see Chapter 3. How to Create a Parameterize Report in the Oracle Application Express Advanced Tutorials.

To create your initial application:

Log in to Oracle Application Express.

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

On the Workspace home page, click Application Builder.

Click the Create button.

The Create Application Wizard appears.

Description of cr_app.gif follows
Description of the illustration cr_app.gif

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 bldap_wiz_steplst.gif follows
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.

For Method, accept the default, Create Application, and click Next.

For Name:

Name - Enter AnyCo Corp.

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

Create Application - Accept the default, From scratch.

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

Click Next.

Next, add a page to your application.

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

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.

Page Name - Enter Home.

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.

Description of cr_app_add_pg.gif follows
Description of the illustration cr_app_add_pg.gif

Next, add a report page on the OEHR_DEPARTMENTS table.

In the Add Page section, specify the following:

Select Page Type - Select Report.

Subordinate to Page - Select Home (1).

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

Page Source - Accept the default, Table.

Table Name - Select OEHR_DEPARTMENTS.

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

Implementation - Accept the default Interactive.

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.

Click the Oehr_Departments link.

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

In the Create Application section, click Next.

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

For Tabs, select No Tabs and click Next.

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

For Attributes, make these changes:

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.

Language - Accept the default, English (United States) (en-us)

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

Date Format - Select the up arrow to select the 12-JAN-04 format from the list of Date formats.

Click Next.

For User Interface, select Theme 18 and click Next.

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.

Description of bldap_cr_app.gif follows
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.

Previewing Your Application

You preview your application by running it. Running the application displays the rendered version of the application as end users would see it.

As you create pages, you can view them by running the page individually or by running the entire application. When you run a page or application, the Application Express engine dynamically renders it into viewable HTML based on data stored in the database.

To run the application, click the Run Application icon.

Description of run_ico_sm.gif follows
Description of the illustration run_ico_sm.gif

To run the page, click the Run Page icon.

Description of run_ico_green.gif follows
Description of the illustration run_ico_green.gif

To preview your application:

On the Application home page, click Run Application.

The first time you run an application you are prompted to enter a user name and password. To continue, simply enter your workspace user name and password and then click Login.

The first time you run an application you are prompted to enter a user name and password. To continue, simply enter your workspace user name and password and then click Login.

You can run the application using your Application Express login credentials because you chose Application Express Authentication when creating the application. For more information, see "Establishing User Identity Through Authentication" in Oracle Application Express Application Builder User's Guide.

The Home page of your application appears.

Description of bldap_home.gif follows
Description of the illustration bldap_home.gif

Notice that a link to the Departments page appears on the Home page because you set up that hierarchy.

Also notice the Developer toolbar at the bottom of the page. These links appear when you run an application within the development environment. The Developer toolbar offers a quick way to edit the current page, create a page, region, or page control, view session state, or toggle in and out of Debug mode.

Click the Departments link.

The Departments report appears.

Description of bldap_dept.gif follows
Description of the illustration bldap_dept.gif

Modifying the Departments Report

When you run the Create Application Wizard, the wizard creates forms and reports based on the selections you make. Behind the scenes, Application Express writes a query for you to extract the appropriate data from the database.

In this exercise, you modify the query for the Departments report to include information from the OEHR_EMPLOYEES table. Three columns from the OEHR_EMPLOYEES table, Number of Employees, Manager Name and Location, are added to the Departments report. The Manager Name column replaces the Manager Id column and the Location column replaces the Location Id column.

To modify the Departments report:

Click the Edit Page 2 link on the Developer toolbar (at the bottom of the page).

The Page Definition for Page 2 appears. A page is the basic building block of an application. Pages contain user interface elements such as tabs, lists, buttons, items, and regions. To see the definition of each page belonging to your application, you use the Page Definition page. For more information, see "What Is Application Builder?".

Under Page Rendering, locate the Regions section.

Description of bldap_reg.gif follows
Description of the illustration bldap_reg.gif

Click Departments.

Scroll down to Source, and replace the default Region Source script with the following:

SELECT d.DEPARTMENT_ID,
    d.DEPARTMENT_NAME,
    (select count(*)from oehr_employees where department_id = d.department_id)  "Number of Employees",
    substr(e.first_name,1,1)||'.'||e.last_name "Manager Name",
    c.COUNTRY_NAME "Location"
FROM OEHR_DEPARTMENTS d,
   OEHR_EMPLOYEES e,
   OEHR_LOCATIONS l,
   OEHR_COUNTRIES c
WHERE d.LOCATION_ID=l.LOCATION_ID
    AND l.COUNTRY_ID=c.COUNTRY_ID
    AND d.DEPARTMENT_ID=e.department_id
    AND d.manager_id=e.employee_id
    AND instr(upper(d.department_name),upper(nvl(:P2_REPORT_SEARCH,d.department_name)))>0

Click Apply Changes.

Click Apply Changes to confirm.

Under the Regions section, click the Interactive Report link.

Click Edit icon next to Number of Employees.

Under Column Definition, select center for Column Alignment.

Click Apply Changes.

Run the Report to View Added Columns

To see how the page looks to end users, run the page. When you run a page, the Application Express engine dynamically renders and processes the page to display viewable HTML.

To run the page:

Click the Run Page icon in the upper right corner.

Description of runpg_iconrow.gif follows
Description of the illustration runpg_iconrow.gif

The revised Departments report appears.

Description of bldap_deptexp.gif follows
Description of the illustration bldap_deptexp.gif

To add the new columns, click the Actions menu. The list of Action options appears.

Description of bldap_addcolumn.gif follows
Description of the illustration bldap_addcolumn.gif

Note that the Manager Id and Location Id columns are no longer available. Also note that the three new columns are not displayed on the revised report: Number of Employees, Manager Name, and Location. The following steps are required to add these columns to the display and reorder them.

Select Select Columns.

The columns that were added by the new SQL, Location and Manager Name, are in the Do Not Display box.

Click the Move All icon to add these three columns to the Display in Report box. The Move All icon looks like the following figure. Description of bldap_moveall.gif follows
Description of the illustration bldap_moveall.gif

Use the up and down arrows to the right of the Display in Report to put the columns in this order:

Description of bldap_reorder.gif follows
Description of the illustration bldap_reorder.gif

Click Apply.

The Departments page appears and includes the new columns.

Description of bldap_deptnew.gif follows
Description of the illustration bldap_deptnew.gif

Using an Interactive Report

This exercise guides you through some commonly used report options available to users when they run interactive reports. These options allow the user to perform certain tasks quickly.

See Also:

For an overview of all Interactive Report components see How to Create a Parameterized Report in the Oracle Application Express Advanced Tutorials.

Topics included in this section:

Save Report Settings as the Default

Create a Filter

Change the Sort Order

Add a Controlled break

Reset Report Settings

You already used the Select Column option from the Actions menu to add columns to the report display. In this section, you run the application and use some of the various search, sort, highlight and reset features to manipulate the Departments interactive report.

This tutorial only touches on some of the most prominent functionality available with interactive reports. For complete details refer to the Oracle Application Express Advanced Tutorials and Oracle Application Express Application Builder User's Guide.

Save Report Settings as the Default

If the report settings are not saved as the default, the columns added to the display in the previous steps are not displayed when the application is restarted or when the report is reset.

To save current report settings as the default:

Select the Actions menu.

Select Save Report.

The Save Report settings appear.

Select As Default Report Settings from the Save drop down.

Description of bldap_default.gif follows
Description of the illustration bldap_default.gif

Click Apply.

The report will show all columns when the user selects the Reset option from the Actions menu or when the page is reset by a Reset Interactive Report command, RIR.

See Also:

For a description of how to save as a report as a Named Report see How to Create a Parameterized Report in the Oracle Application Express Advanced Tutorials.

Create a Filter

This exercise shows you how a user can add a filter to the Departments report. This example creates a filter to show all departments with the exception of departments with an Id of 60.

There is more than one way a user can create a filter. The user can add a filter from the:

Search Bar

Actions Menu

Column Heading

The Actions menu offers more options than the others. For a quick filter using the equals operator, the Search Bar or column heading are the quickest methods. For anything else, use the Filter option from the Actions menu.

To create a filter for all departments not equal to 60:

Select the Actions menu.

Select Filter.

The filter settings display. Note the user can also click the column heading link to create a filter for that column. Creating a filter from the column heading menu, however, is limited to the equal operator.

Description of bldap_filter.gif follows
Description of the illustration bldap_filter.gif

From the Operator drop down, select the not equals operator:

!=

Select 60 from the Expression drop down.

Click Apply.

The Departments report is displayed with the Department_Id!=60 filter applied. All departments, accept for the IT department with a Department Id of 60, are included in the report.

Description of bldap_dept60.gif follows
Description of the illustration bldap_dept60.gif

Notice the filter is shown at the top of the report. You can edit, disable, or delete this filter. To edit, click on the filter name. To disable, uncheck the check box. To delete, click on the Delete icon that looks like an X over the filter icon.

Uncheck the check box next to the Department Id!=60 filter to disable it.

The report shows data for all Department Ids.

Change the Sort Order

In this exercise, you learn how the user can reorder the data for each column.

To change the sort order:

Select the Actions menu.

Select Sort.

The sort settings are displayed. Note this option is also available for each column by clicking the column heading. The Actions menu is quicker when changing the sort order for multiple columns.

Select Department Name for the first column entry.

Description of bldap_actionsort.gif follows
Description of the illustration bldap_actionsort.gif

Click Apply.

The report shows the Department Name column in ascending alphabetical order.

Description of bldap_ascend.gif follows
Description of the illustration bldap_ascend.gif

Notice the up arrow icon after the Department Name that indicates the column has been sorted in ascending order. You can click on this arrow to resort the column.

Add a Controlled break

Another Actions menu option the user can select to reformat the report, is the controlled break. This allows the user to delineate data into clearly visible groups.

To add a controlled break:

Click the Location column heading.

The column heading menu appears.

Click the Control Break icon as shown below.

Note this same option is also available from the Actions menu.

Description of bldap_ctlbrk.gif follows
Description of the illustration bldap_ctlbrk.gif

The report is reformatted to show a break after each group of rows that share the same location.

Description of bldap_locbrk.gif follows
Description of the illustration bldap_locbrk.gif

Note the Location control break report setting has been added under the Department Id!=60 filter.

Display the Single Row View

The user can display details for a row by selecting the Single Row icon.

To display the single row view:

Locate the Single Row View icon for the first row.

Description of bldap_singlerow.gif follows
Description of the illustration bldap_singlerow.gif

Select the Single Row View icon for the first row.

The details page for the first row appears.

Description of bldap_details.gif follows
Description of the illustration bldap_details.gif

Reset Report Settings

The user can revert the report settings back to the saved default settings.

When an interactive report is reset, the default settings are applied to the report. An interactive report can be reset by the user and by the developer under the following conditions:

A user can reset an interactive report if the Reset option is available from the Actions menu. This option is enabled or disabled by the developer. For further details see "Editing Interactive Reports" in the Oracle Application Express Application Builder User's Guide.

A developer can specify that an interactive report be reset when it is called from another page. The Reset Interactive Report command, RIR, is used for this purpose. For further details see "Editing Interactive Reports" in the Oracle Application Express Application Builder User's Guide.

To return to the default settings:

Select the Departments breadcrumb.

Select the Actions menu.

Select Reset.

Click Apply.

The report goes back to the default report settings saved in the previous section.

Adding an Employees Report and Form

In this exercise, you add a report to display employee information and a form to create, update, and delete employee information.

To add an employee report and form:

Click the Application ID link on the Developer toolbar (at the bottom of the page).

The Application home page appears.

Click Create Page.

For Page:

Select Form and click Next.

Select Form on a Table with Report.

This option creates two pages, a report and form, based on a single table or view.

Click Next.

For Table/View Owner, accept the default and click Next. This specifies the schema owner.

For Table/View Name, select OEHR_EMPLOYEES and click Next.

For Define Report Page, make these changes:

Implementation - Select Interactive.

Page Name - Change to Employees.

Region Title - Change to Employees.

Breadcrumb - Select Breadcrumb.

The Create Breadcrumb Entry section appears.

For Select Parent Entry, click the Home link.

Home appears in the Parent Entry field.

Click Next.

For Define Report Page, accept the default, Do not use tabs, and click Next.

For Define Report Page, press the Ctrl key, select the following columns, and click Next:

EMPLOYEE_ID

FIRST_NAME

LAST_NAME

HIRE_DATE

SALARY

COMMISSION_PCT

The columns you selected appear on the Report page when the page is run.

For Define Report Page, accept the defaults and click Next.

Note that the default Edit Link image resembles a small piece of paper and pencil.

Next, define the page and region information for the form.

For Define Form Page, edit the following:

Page Name - Enter Create/Edit Employee.

Region Title - Enter Create/Edit Employee.

Entry Name - Enter Create/Edit Employee.

Click Next.

In Primary Key, accept the defaults and click Next.

In Define the source for the primary key columns, accept the default, Existing trigger, and click Next.

Your table, OEHR_EMPLOYEES, already has a trigger that populates the primary key.

In Select Column(s), select all columns and click Next.

These columns appear in the Create/Edit Employee form when the page is run.

In Identify Process Options, accept the defaults and click Next.

These selections enable users to add, update, and create employee records.

For Confirm, verify the information and click Finish.

Previewing the Pages

To preview the two pages you just created, run the current page. From the Employees report, you can then preview the form.

To preview the pages:

Click the Run Page icon.

Description of runpg_afterwiz.gif follows
Description of the illustration runpg_afterwiz.gif

The Employees report appears.

Description of bldap_emprpt.gif follows
Description of the illustration bldap_emprpt.gif

Note the following about the Employees report:

The Search Bar with the Actions menu appears at the top. For more information see Using an Interactive Report .

The column headings are links that allow the user to quickly perform various sorting, filtering and reformatting operations. For more information see Using an Interactive Report .

The Edit icon you selected appears in each row. You can click the Edit icon to update the employee record. Since you created a form based on a table with a report, the wizard automatically linked the report to the form. If you create just a report, as is done in the previous Creating the Initial Application section, the wizard automatically links the report to the single row view.

The Create button appears in the upper right corner. You can click the Create button to add an employee to the underlying table.

The Employees report includes the five columns you specified. When you selected the columns and applied the changes, Oracle Application Express created the appropriate SQL code in the background to produce this result.

Your data might appear in a different order. If so, ignore this difference and continue with these steps.

To review the form you also created, click the Edit icon in an Employee row.

The Create/Edit Employee form appears.

Description of bldap_empeditfrm.gif follows
Description of the illustration bldap_empeditfrm.gif

Note the following about the Create/Edit Employee form:

The form includes Cancel, Delete, and Apply Changes buttons.

The Hire Date field displays a calendar, which is included because the data type of the underlying column is DATE.

Fields labeled in red require entries.

Editing the Employees Report

In this exercise, you create a new column titled Remuneration to display employees' salaries in the Employees report.

Topics in this section include:

Create a Function

Add a Column

Previewing the Page

Changing the Column Format

Create a Function

First, create a function to calculate employees' salaries.

To create a function:

Click the Home link on the Developer toolbar.

Click SQL Workshop and then SQL Commands.

SQL Commands provides a window where you can run PL/SQL against the database.

In the SQL editor, enter the following script:

CREATE OR REPLACE FUNCTION calc_remuneration(
    salary IN number, commission_pct IN number)
RETURN NUMBER IS
BEGIN
    RETURN ((salary*12) + (salary * 12 * nvl(commission_pct,0)));
END;

When copying and pasting this SQL, make sure there is not an empty line before the first statement, CREATE OR REPLACE FUNCTION.

Click Run.

The Results section displays this message:

Function created.

Add a Column

Next, add a column to display the results of the employees' salary calculations.

To add a column:

Navigate to the Page Definition for page 3:

Click the Application Builder tab.

Select the AnyCo Corp application.

Click 3 - Employees.

The Page Definition for page 3, Employees, appears.

Under Regions, click the Employees link (next to Interactive Report).

Description of bldap_emprjn.gif follows
Description of the illustration bldap_emprjn.gif

The Region Definition appears.

Scroll down to Source, and replace the existing code with the following:

SELECT "EMPLOYEE_ID",
    "FIRST_NAME",
    "LAST_NAME",
    "HIRE_DATE",
    "SALARY",
    "COMMISSION_PCT",
    calc_remuneration(salary, commission_pct) REMUNERATION
FROM "#OWNER#"."OEHR_EMPLOYEES"

Click Apply Changes.

Click Apply Changes to confirm.

Previewing the Page

To preview the page, click the Run Page icon in the upper right corner. Notice the Remuneration column does not appear. You must add the column by using the Select Column action.

Description of bldap_emprpt.gif follows
Description of the illustration bldap_emprpt.gif

To display the Remuneration column:

Select the Actions menu.

Select the Select Columns action.

Move the Remuneration column from the Do Not Display box to the Display in Report box.

Description of bldap_addrem.gif follows
Description of the illustration bldap_addrem.gif

Click Apply.

The Employees Report is displayed and includes the Remuneration column.

Description of bldap_empfrmrem.gif follows
Description of the illustration bldap_empfrmrem.gif

Changing the Column Format

Next, change the format of the columns that contain numeric values.

To change the column format:

Click Edit Page 3 on the Developer toolbar (at the bottom of the page).

The Page Definition appears.

Under Regions, click Interactive Report.

The Interactive Report Attributes page appears.

Locate the Column Attributes section.

Next, change the format of the value in the Salary and Remuneration columns.

To edit the Salary format:

Click the Edit icon next to SALARY.

For Number/Date Format, select $5,234.10 from the list.

Notice that the appropriate format mask appears in the field.

Click Apply Changes.

Repeat the previous step for REMUNERATION.

Click the Run Page 3 icon in the upper right corner to preview the page.

Notice that the numbers in the Salary and Remuneration columns now appear with the dollar sign, include commas and decimals, and are correctly aligned.

Description of bldap_emprptnum2.gif follows
Description of the illustration bldap_emprptnum2.gif

Adding a Link on the Home Page to the Employees Report

In this exercise, you add a link on the Home page to take users to the Employees report. This link appears in the Navigation region on the left side of the Home page.

To add a link on the Home page to the Employees report:

Navigate to the Page Definition for the Home page, page 1:

Click Application in the Developer toolbar (at the bottom of the page).

On the Application home page, click Home.

Under Regions, click the List link (next to Navigation).

On the List Entries page, click the Create List Entry button on the right side of the page.

On the Create/Edit List Entry page, edit the following:

Sequence - Change to 20.

List Entry Label - Enter Employees.

Page - Enter 3.

Click Create.

Run the page.

Description of bldap_homeemp.gif follows
Description of the illustration bldap_homeemp.gif

Notice that your Home page now includes a link to Employees.

Click Employees to test the link. The Employees report appears.

Adding a Department Column to the Employees Reports

In this exercise, you link the Employees and Departments reports. When you complete this section, the Employees report will have a Departments column showing which department each employee belongs to.

To perform this task, you create a column on the Employees page to enable the user to select a department. You then run the Employees report and add the Departments column to the report display. The report settings are saved as the default.

Topics in this section include:

Add a Column

Display Column in the Report

Save Report Settings as the Default

Add a Column

In order to filter the Employees report by department, add a Department column to the report.

To add a column:

Click on Edit Page 3 in the Developer toolbar.

Under Regions, click Employees and scroll down to Source.

Replace Region Source with the following SQL:

SELECT e.EMPLOYEE_ID,
    e.FIRST_NAME,
    e.LAST_NAME,
    e.HIRE_DATE,
    e.SALARY,
    e.COMMISSION_PCT,
    calc_remuneration(salary, commission_pct) REMUNERATION,
    e.DEPARTMENT_ID,
    d.DEPARTMENT_NAME
FROM OEHR_EMPLOYEES e,
    OEHR_DEPARTMENTS d
WHERE e.DEPARTMENT_ID=d.DEPARTMENT_ID

Click Apply Changes.

Click Apply Changes to confirm.

The next section explains how to add the column to the report display and how to use this column to filter employee reports.

Display Column in the Report

When you first run this report, use the Select Columns action to add the Department Name column to the display. Once this column is visible on the report, make this report the default and filter by department.

To add the Department Name column to the report:

Click Run Page 3 icon.

Select the Actions menu and select Select Columns from the list.

Move the Department Name from the Do Not Display box to the last entry in the Display in Report box. Description of bldap_deptcol.gif follows
Description of the illustration bldap_deptcol.gif

Click Apply.

The Employees Report is displayed and includes the Department Name column.

Description of bldap_empdept.gif follows
Description of the illustration bldap_empdept.gif

Next, make these report settings the default.

Save Report Settings as the Default

This section describes how to save the current report settings as the default. Report settings are any setting made through the Actions menu including: selected columns, filters, sorting, control breaks, highlights, computed columns, aggregate columns, charts, flashback.

In this example, the default settings include the display of all columns with no additional Actions menu settings such as filters, sorting, highlights and so on in the report. Once the default settings are saved, these columns are the default display in this report:

Employee Id

First Name

Last Name

Hire Date

Salary

Commission Pct

Remuneration

Department Name

To save the current report settings as the default:

Run the Employees report page.

The current report default does not include the Department Name column when the report is displayed.

Click the Actions menu.

Select Save Report from the list.

For Save, select As Default Report Settings from the list.

Click Apply.

Note:

If a reset is performed on this page, these default report settings are used. The Department Name column is displayed by default.

Linking a Column Value to Another Page

In this exercise, you add a link to the Number of Employees column on the Departments report that navigates the user to the Employees report. It also sets the focus to the selected department. The column link includes a Clear Interactive Report command, CIR, to clear the Employees report, when shown, of any filters, control breaks, highlights, aggregates, computed columns, chart settings and flashback settings.

Topics included in this section:

Change Column Value to a Link

Run the Departments Report

Create a Highlight to Test Clear Interactive Report Command

Change Column Value to a Link

To make this change, you edit the report attributes on the Departments report to change the value for the Number of Employees column to a link.

To change the column value to a link:

Navigate to the Page Definition for the Departments page, page 2.

Under Regions, click Interactive Report.

The Interactive Report Attributes page appears.

Locate the Column Attributes section.

In the Column Attributes section, click the Edit icon next to Number of Employees.

Scroll down to the Column Link section.

Under Column Link, make these changes:

Link Text - Select [Number of Employees]

Page - Enter 3.

Select the Reset Pagination check box.

Clear Cache - Enter 3,CIR

The 3 means the cache for page 3 is cleared and the string CIR clears the Employees interactive report of any filters, control breaks, highlights, aggregates, computed columns, chart settings or flashback settings when the report is displayed.

Note:

If you want to reset the interactive report to the default report settings instead of clear the report, replace CIR with RIR. The last saved default report settings are applied to the interactive report.

Item 1, Name - Enter IR_DEPARTMENT_ID.

By prefixing the item name with IR_, the URL item will be associated with an interactive report column rather than an item on the page.

Item 1, Value - Select #Department ID#.

The Column Link section shows all the options you selected.

Description of bldap_setnumlink.gif follows
Description of the illustration bldap_setnumlink.gif

In summary, these options enable the following behavior when the end user clicks the link:

The end user is navigated to page 3, the Employees report.

On the Employees report, the selected department is in focus.

The Employees report is cleared. This means any filters, control breaks, highlights, aggregates, computed columns, chart settings or flashback settings are removed.

The user is returned to the first set of employee records when the user selects another department.

Click Apply Changes.

Note that in the Column Attributes section, the Number of Employees row contains a check mark in the Link column, reflecting the change you just made.

Run the Departments Report

Now it's time to run the report and test the Number of Employees column link from the Departments report. The Employees report is displayed showing all employees that belong to the selected department.

Click the Run Page 2 icon.

The Departments report is displayed. Note that end users can now drill down on the data in the Number of Employees column.

Description of bldap_numemplink.gif follows
Description of the illustration bldap_numemplink.gif

In the Number of Employees column, click the 3 for the Executive row.

All employees that belong to the Executive department appear in the Employees report.

Description of bldap_emplink.gif follows
Description of the illustration bldap_emplink.gif

The Department Id filter is displayed because this report is filtered by the Department Id value for the Executive department, 90, passed to this report from the Departments report. Notice the Clear Interactive Report command is included at the end of the URL in your browser, as shown in this example:

f?p=9257:3:3672543193352902::NO:RP,3,CIR:IR_DEPARTMENT_ID:90

Create a Highlight to Test Clear Interactive Report Command

This exercise demonstrates how to use the CIR command to clear a highlight before displaying the Employees report. To show this, you highlight any rows containing the first name of Neena, then display the Employees report from the Number of Employees column on the Departments report.

To highlight rows in the Employees report:

Click the Actions menu and select Highlight.

The Highlight options appear.

For Highlight options make these changes:

Name - Enter Neena

Background Color - Select [yellow]

Text Color - Select [blue]

Column - Select First Name

Operator - Select =

Expression - Select Neena

Click Apply.

The Employees report appears with the row for Neena highlighted.

Description of bldap_high.gif follows
Description of the illustration bldap_high.gif

Click the Home breadcrumb.

Click Departments link.

Click Number of Employees in the Executive row.

The Employees report is displayed with the highlighting cleared, due to the CIR command specified in the column link.

Adding a Conditional Department Details Report

In this exercise, you add a report as a region that displays department details. You also create a condition so that the report displays department information only if you select a department. If you select No Department Assigned, the Department Details report does not appear.

Topics in this section include:

Creating the Report and Condition

Add a List of Values

Add an Item to Display List of Values

Add a Branch

Change Employees Report Query

Change Column Link on Department Report

Turning Off Pagination

Creating the Report and Condition

First, create the report and set it to conditionally display.

To create the report and condition:

Navigate to the Page Definition for page 3, Employees.

Under Regions, click the Create icon.

For Region, make these changes:

Identify the type of region to add to this page - Select Report and click Next.

Report Implementation - Accept the default, SQL Report, and click Next.

For Display Attributes, make these changes:

Title - Enter Department Details.

Region Template - Select No Template.

Sequence - Enter 7.

Accept the remaining defaults and click Next.

For Source, make this change:

Enter the following query:

SELECT count(e2.employee_id) "Number of Employees:",
    substr(e.first_name,1,1)||'. '|| e.last_name "Manager Name:",
    c.country_name "Location:"
    FROM  oehr_departments d, oehr_employees e,
        oehr_locations l, oehr_countries c,
        oehr_employees e2
    WHERE d.manager_id    = e.employee_id
    AND d.location_id   = l.location_id
    AND d.department_id = e2.department_id
    AND l.country_id    = c.country_id
    AND nvl(d.department_id,'-1') = nvl(:P3_DEPARTMENT_ID,'-1')
    GROUP BY substr(e.first_name,1,1)||'. '||e.last_name,  c.country_name

Click Next.

Next, you create a condition that does not display department details when the user selects the No Department Assigned option.

For Report Attributes, make these changes:

Report Template - Select default: vertical report, look 1 (include null columns).

This selection displays the list vertically.

Accept the remaining defaults and click Next.

For Conditional Display, make these changes:

Condition Type - Select Value of Item in Expression 1 != Expression 2.

Note the exclamation point (!) included after Expression 1 in the option to select.

Expression 1 - Enter:

P3_DEPARTMENT_ID

Expression 2 - Enter:

-1

The -1 indicates no Department has been assigned.

Click Create Region.

Under Regions, click Create icon.

Select HTML and click Next.

Select HTML and click Next.

For Create Region, make these changes:

Title - Enter Department

Region Template - Select No Template

Sequence - Enter 5

Click Create.

Add a List of Values

In this section, you create a list of values that is used to select which department details to view. This is a dynamic list that queries the OEHR_DEPARTMENTS table for a list of all the department names.

To create a list of values:

Click Shared Components icon at the top right next to the Run Page 3 icon.

Under User Interface, select Lists of Values.

Click the Create button.

Accept the default, From Scratch, and click Next.

For Name, enter DEPARTMENTS and select Dynamic.

Click Next.

For the Query, enter the following SQL:

SELECT department_name d, department_id v
    FROM oehr_departments
    ORDER BY d

Click Create List of Values.

Add an Item to Display List of Values

Now, you create an item in the Department Details region to display the list of departments.

To add an item:

Navigate to the Page Definition for page 3, Employees.

Under Items, click the Create icon.

Select Select List and click Next.

Select Select List with Submit and click Next.

For Create Item, make these changes:

Item Name - Enter P3_DEPARTMENT_ID

Sequence - Enter 10

Region - Select Department (1) 5

Click Next.

For Identify List of Values, make these changes:

Named LOV - Select DEPARTMENTS

Display Null Option - Select Yes

Null Text - Enter - No Department Assigned -

Null Value - Enter -1

Click Next.

For Label, enter Department and click Next.

For Item Source Value, enter -1

Click Create Item.

Add a Branch

You need to add a branch that returns to the Employees page 3 when the user chooses a department from the Department list of values.

Under Branches, click the Create icon.

Accept defaults and click Next.

For Page, enter 3.

Select reset pagination for this page and click Next.

Accept defaults and click Create Branch.

Change Employees Report Query

Now, you change the Employees report query to display employees that belong to the selected department.

To change the query:

Under Regions, click the Employees link.

Enter the following SQL for Region Source:

SELECT  e.EMPLOYEE_ID,
        e.FIRST_NAME,
        e.LAST_NAME,
        e.HIRE_DATE,
        e.SALARY,
        e.COMMISSION_PCT,
        calc_remuneration(salary, commission_pct) REMUNERATION,
        e.DEPARTMENT_ID,
        d.DEPARTMENT_NAME
  FROM  OEHR_EMPLOYEES e,
        OEHR_DEPARTMENTS d
 WHERE  e.DEPARTMENT_ID = d.DEPARTMENT_ID(+) AND
        (e.DEPARTMENT_ID = :P3_DEPARTMENT_ID or
        (e.DEPARTMENT_ID is null and nvl(:P3_DEPARTMENT_ID,'-1') = '-1'))

Click Apply Changes.

Change Column Link on Department Report

Because the Employees query has changed, the Number of Employees column link needs to initialize the P3_DEPARTMENT_ID item to the value of DEPARTMENT_ID.

To change the column link for Number of Employees:

Click the Application ID breadcrumb.

Click 2 - Departments.

Under Regions, click the Interactive Report link.

Click the Edit icon for Number of Employees.

Under Column Link, enter P3_DEPARTMENT_ID for Item 1.

Click Apply Changes.

Turning Off Pagination

Next, turn off pagination for the Department Details report, because only one record (the department details report) displays at a time. If pagination is on, the region that displays the department details includes the information row 1 - 1.

To turn off pagination:

Click the Application ID breadcrumb.

Click 3 - Employees.

Under Regions, click Report (next to Department Details).

Scroll down to Layout and Pagination.

For Pagination Scheme, select - No Pagination Selected -.

Click Apply Changes.

Run the page.

To remove the Department id = 90 filter, select the Remove Filter icon next to the filter.

From the Department list, select No Department Assigned.

Description of bldapp_nodptassgn.gif follows
Description of the illustration bldapp_nodptassgn.gif

Employee Kimberely Grant appears. This employee is not currently assigned to a department. Therefore, no department details appear. The 1 - 1 you see on this form is part of the Employees report, not part of the Department Details region you just edited.

From the Department list, select Marketing.

Description of bldapp_dptdetail.gif follows
Description of the illustration bldapp_dptdetail.gif

Note the details under Department.

Adding Your Company Name

You can add a graphical logo or text to your application so that it displays on each page. Your page template determines the display location.

In this exercise, you add your company name to your application.

To add your company name to your application:

Navigate to the Application home page. Click the Application link on the Developer toolbar (at the bottom of the page).

Click Shared Components.

Under Application, click Definition.

The Edit Application Definition page appears.

Under Logo:

Logo Type - Select Text.

Logo - Enter AnyCo Corp.

Logo Attributes - Select Black Text from the pop up list.

Click Apply Changes.

Click Application link on Developer toolbar.

Click Run Application icon.

Description of bldap_compname.gif follows
Description of the illustration bldap_compname.gif

The company name now appears on each page in your application.

Switching Themes to Change the User Interface

In this exercise, you switch the current theme to another one for your application. A theme is a collection of templates that defines the application user interface. Each theme contains templates for every type of application component and page control, including individual pages, regions, reports, lists, labels, menus, buttons, and list of values.

Oracle Application Express separates presentation (or user interface themes) from the application logic. You can design your application in one theme, change to another supplied theme, or create and use your own custom theme. By separating the application logic (such as queries, processes, and branches) from the HTML rendering, your application can take advantage of the latest designs and other technological advances without an application rewrite. Each theme provides a complete set of templates that accommodate every user interface pattern that may be needed in an application.

To switch the theme:

Click the Application link on the Developer toolbar (at the bottom of the page).

On the Application home page, click Shared Components.

Under User Interface, click Themes.

Description of bldap_sharcomp.gif follows
Description of the illustration bldap_sharcomp.gif

On the Themes page, click Create.

The Create Theme Wizard appears.

For Method, accept the default, From the Repository, and click Next.

For Identify Theme, select Theme 11 and click Next.

For Confirm, click Create.

Click Switch Theme.

For Identify Theme, accept the default, 11. Round Green, and click Next.

For Verify Compatibility, review the information, accept the defaults, and click Next.

The wizard verifies that corresponding templates exist in the selected theme for all templates used in your current application. If a template is missing, it warns you with a message in the Status column. For this tutorial, you can ignore this message because Oracle Application Express maps missing region templates to existing ones.

For Confirm Switch, click Switch Theme.

Run the page.

Description of bldap_newtheme2.gif follows
Description of the illustration bldap_newtheme2.gif

The color scheme and display layouts are changed in all your pages.

5 About Deploying Your Application

This section describes basic information about deploying your Oracle Application Express application. It also shows you how to create end users and to determine the URL of your application.

This section contains the following topics:

Overview of Deploying Your Application

Creating End Users

About Publishing the Application URL

Overview of Deploying Your Application

After building your application in your development environment, you need deploy it so that end users can begin using it. Deploying involves the following steps:

Collect your supporting object definitions (CREATE object statements, sample data, images, files, and so on). Review the Database Dependencies report to determine which supporting objects to move. See "Viewing Application Reports" in Oracle Application Express Application Builder User's Guide.

Define your supporting objects. This includes the object definitions you collected in the previous step and other supporting objects, such as messages and prerequisites.

Export the application with its supporting objects.

Import and install the exported files.

Using Oracle Application Express greatly simplifies the deployment process. It enables you to migrate the application definition, associated files, and all supporting objects in just a few steps.

See also:

"Deploying an Application" in Oracle Application Express Application Builder User's Guide.

Creating End Users

After moving your application to a production environment, you must now create user accounts within Oracle Application Express for all your end users.

To create end user accounts:

Navigate to the Workspace home page.

From the Administration links list on the right, click Manage Application Express Users.

Under the Tasks list on the right, click the Create End User link.

The Create User page appears.

Description of deploy_cr_enduser.gif follows
Description of the illustration deploy_cr_enduser.gif

Under Account Control:

Set Account Availability - Select Unlocked.

Require Change of Password On First Use - Select No if you do not want to force this user to change his or her password at first log in.

Under User Identification, enter the appropriate information:

User Name - Enter a user name for this end user.

Password and Confirm Password - Enter a case-sensitive password for this account.

Email Address - Enter the valid email address for this end user.

Under Developer Privileges:

Accessible Schemas (null for all) - Leave this blank to allow the end user to access all applications in the workspace, or enter a colon-delimited list of schemas to restrict the end user's access.

If a user does not have access to the schema that an application is built on, the user cannot access the application.

Default Schema - Accept the default value, that is, the schema you set up for this guide.

User is a developer - Accept the default, No.

User is a workspace administrator - Accept the default, No.

Selecting No limits the user to only accessing and using the application, not modifying the application itself.

Under User Groups, you can select a user group.

You can use groups to restrict access to various parts of an application. Groups are primarily useful when using Application Express Authentication.

Under Additional Attributes, you can enter additional user information.

Click Create User or Create and Create Another.

See also:

"Managing Application Express Users" in Oracle Application Express Administration Guide

About Publishing the Application URL

After deploying your application, you must now publish its URL so end users know how to access it.

To determine the URL:

Log in to Oracle Application Express on the production environment.

Select the application.

On the Application home page, position the mouse over the Run Application icon.

Note the URL that displays in the status bar at the bottom of the page.

For example:

http://apex.oracle.com/pls/apex/f?p=11563:1:3397731373043366363

Where:

apex.oracle.com is the URL of the server.

pls is the indicator to use the mod_plsql.

apex is the database access descriptor (DAD) name. The DAD describes how Oracle HTTP Server connects to the database server so that it can fulfill an HTTP request. The default value is apex.

f?p= is a prefix used by Oracle Application Express.

11563 is the application being called.

1 is the page within the application to be displayed.

3397731373043366363 is the session number, which is unique for every user's access to the application. Do not include session numbers as a part of the URL communicated to end users.

To run this example application, you would go to this URL:

http://apex.oracle.com/pls/apex/f?p=11563:1

See also:

"Deploying an Application" in Oracle Application Express Application Builder User's Guide

6 About Globalization

This section describes some basic information about globalization. It also leads you through the steps to specify how the application determines global identification.

This section contains the following topics:

About Language Identification and Rendering

Specifying the Method for Global Identification

About Language Identification and Rendering

You can develop applications in Application Builder that run concurrently in different languages. This feature enables different users to view the application in their own language and data in the appropriate formats.

When rendering a page in the application, Oracle Application Express first determines the language for an application based on the method you specified. Then, the Application Express engine alters the session language and territory settings for a specific page request. It then looks for a translated application in the appropriate language. If the Application Express engine finds that language, it renders the application using that definition. Otherwise, it renders the application in the base (or primary) application language.

Even if your application is not translated, the language display determines the format for displaying data so that end users view numbers, dates, and currency in the appropriate formats.

Specifying the Method for Global Identification

As part of the application definition settings, you can specify how the application determines which language and formats to display. You can base it on the user's browser language preference or restrict it to the language you specify.

To specify the method for determining global identification:

Click Application Builder and then select the application.

Click Shared Components.

Under Globalization, click Edit Attributes.

Under Globalization, specify the following:

Application Primary Language - Select the language you used when developing the application.

Application Language Derived From - Select Browser (use browser language preference).

This option enables users to view the application in the language specified in their browsers.

Automatic CSV Encoding - Select Yes or No.

Automatic CSV Encoding controls the encoding of all comma-delimited (CSV) report output in an application. If Automatic CSV Encoding is set to Yes, CSV report output is properly converted to a character set compatible with localized desktop applications. The character set for the CSV encoding is determined by the Application Language Derived From setting.

Description of glb_settings.gif follows
Description of the illustration glb_settings.gif

For example, the end user whose browser setting is German (de) sees these changes on the Employees page of AnyCo Corp:

The euro currency symbol appears for the amounts in the Salary and Remuneration columns.

The amounts reflect the formatting used in Germany (commas and decimals).

The Hire Date reflects the date format used in Germany.

Description of glb_german.gif follows
Description of the illustration glb_german.gif

Note that the application fields are not yet translated. For instructions on translating your application, see "Managing Application Globalization" in Oracle Application Express Application Builder User's Guide.

7 Next Steps

Now that you have completed this guide, you are ready to take advantage of other resources to expand your knowledge of Oracle Application Express and boost your productivity. This section describes those resources.

This section contains the following topics:

Downloading Public Packaged Applications and Sample Code

Additional Resources

Downloading Public Packaged Applications and Sample Code

If you are using Oracle Application Express 2.2 or later, you can download packaged applications and sample code from the Oracle Application Express Web site. Packaged applications are fully functional applications that you can view, use, and customize. Sample code is provided as packaged applications that contain code examples to explain a solution.

To download public packaged applications and sample code:

In a Web browser, go to the following Web sites:

http://www.oracle.com/technology/products/database/application_express/packaged_apps/packaged_apps.html

Scroll down to review the available applications or code.

Click the link for the file you want to download, and save the file to your computer.

Unzip the file.

Log in to the workspace in Oracle Application Express where you want to use the packaged application or code.

Import and install the application.

Follow the same steps you performed when installing the sample objects for this guide. See "Importing the OEHR Sample Objects".

Additional Resources

To continue learning about Oracle Application Express, review these additional resources designed for Application Express users.

Advanced Tutorials

This guide provides exercises to expand your understanding of Oracle Application Express. See Oracle Application Express Advanced Tutorials.

Training Courses

You can attend training courses for Oracle Application Express. To review these courses, go to the following Web site and enter Application Express in the search criteria field:

http://education.oracle.com

Oracle Technology Network

Oracle Technology Network (OTN) is a central Web site for Oracle Application Express resources and information. In addition to downloading the latest product version, sample code, and packaged applications, the OTN site includes:

Discussion forum, where you can post questions and search for solutions

How-to documents, which are technical notes written by subject matter experts

Quick tour of the product

Oracle by Example provides step-by-step tutorials which demonstrate common tasks

News and magazine articles related to Oracle Application Express

To access OTN for Oracle Application Express:

Log in to Oracle Application Express.

On the Workspace home page, click Oracle Technology Network or Discussion Forum in the Links section on the right side of the page.

Note:

If you are not currently using Oracle Application Express, you can go directly to this OTN Web site: http://www.oracle.com/technology/products/database/application_express/index.html

Index

A  B  C  D  E  F  G  H  I  L  N  O  P  Q  R  S  T  U  W 

A

Actions menu

Select Columns action, 4.3.1

adding

an Employees form, 4.5

an Employees report, 4.5

breadcrumbs, 4.5

columns, 4.6.2

end users, 5.2

functions, 4.6.1

links, 4.7

users, 2.4

workspaces, 2.3.2

Administration list

about, 3.1

About Application Express link, 3.1

Administration link, 3.1

Change Password link, 3.1

Manage Application Express Users link, 3.1

Manage Services link, 3.1

Monitor Activity link, 3.1

AnyCo Corp

about, 4.1

about building the application, 4

application

about Departments report, 4.3

about Home page, 4.2.1

adding company name, 4.11

creating, 4, 4.2

deploying, 5, 5.1

globalizing, 6

previewing, 4.2.1

running, 4.2.1

specifying a language preference, 6.1

Application Builder

about, 3.2

Application Express engine

about, 1.2

application overview of, 4.1

architecture

understanding, 1.2

Authentication scheme

selecting, 4.2

B

breadcrumb

creating, 4.5

C

code

downloading samples, 7.1, 7.1

column

changing format, 4.6.4

creating, 4.6.2

Column Link

defining Link Text, 4.9.1

columns

adding, 4.3.1

company name

adding to application, 4.11

condition

creating, 4.10.1

Create Application Wizard

about, 4.2

Create/Edit Employee form, 4.5.1

creating

applications, 4, 4.2

breadcrumbs, 4.5

columns, 4.6.2

end users, 5.2

functions, 4.6.1

links, 4.7

user accounts, 2.4

workspaces, 2.3.2

D

deleting

sample objects, 3.3.2.2

deloyment

about, 5

demo environment

accessing, 2.2

logging in to, 2.2.1

Department Details report, 4.10

Departments report

modifying the query for, 4.3

deploying

an application, 5

overview of, 5.1

Developer Privileges

about, 5.2

Developer toolbar

about, 4.2.1

about Application Id link, 4.5

developers

about, 1.4

development environment

accessing, 2

prerequisites, 2.1

downloading

sample code, 7.1

sample objects, 3.3.1

E

embedded PL/SQL gateway

about, 1.2

Employees form

adding, 4.5

Employees report

adding, 4.5

adding a column, 4.6.2

adding a link, 4.7

changing column format, 4.6.4

creating a function, 4.6.1

defining source for primary key, 4.5

editing, 4.6

end users

about, 1.4

creating, 5.2

environment

setting up, 2.3

F

form

adding, 4.5

function

creating, 4.6.1

G

global identification

specifying a method, 6.2

Globalization settings

Application Language Derived From, 6.2

Application Primary Language, 6.2

Automatic CSV Encoding, 6.2

H

Home page

adding links to, 4.7

hosted demo environment

logging in to, 2.2.1

hosted environment

accessing, 2.2

signing up, 2.2

HR schema

about installing, 3.3

associating with workspace, 3.3.2.3

Human Resources (HR) schema

about installing, 3.3

I

importing

sample objects, 3.3.2

installing

sample objects, 3.3

Interactive Reports

adding, 4.2, 4.5

adding a column, 4.6.2

adding a column link, 4.9.1

adding columns from other tables, 4.3

adding links, 4.7

changing column format, 4.6.4

creating a function, 4.6.1

creating conditions, 4.10.1

editing, 4.6

linking to another Interactive Report, 4.9

making conditional, 4.10

triggers, 4.5

L

language

method for determining, 6.2

preference, 6.1

link

adding to Home page, 4.7

creating, 4.7

linking

to another page, 4.9

local environment

logging in to, 2.3.3

setting up, 2.3

local instance, 2.3.3

logging in to, 2.3.3

logging in to

Application Express, 2.3.3

hosted demo environment, 2.2.1

local instance, 2.3.3

Oracle Application Express Administration Services, 2.3.1

logo

adding to an application, 4.11

N

name

adding to application, 4.11

O

Object Browser

about, 3.1

about Object Selection list, 3.3.3

about Object Selection pane, 3.3.3

viewing objects, 3.3.3

objects

viewing, 3.3.3

OEHR sample objects, 3.3.1, 3.3.2

deleting, 3.3.2.2

OEHR sample objects application, 3.3

Oracle Application Express

about, 1.1

about Application Express Administration Services, 2.3.1

about workspaces, 1.3.1

additional resources, 7.1, 7.2

architecture, 1.2

getting started with, 3

understanding the environment, 1.3

Oracle Application Express Administration Services

logging in to, 2.3.1

Oracle Application Express administrator

about, 1.4

Oracle HTTP Server (Apache)

about, 1.2

Oracle Technology Network

accessing, 7.2

Order Entry (OE) schema

about installing, 3.3

OTN

accessing, 7.2

P

packaged application

downloading, 7.1

Page Definition

about, 3.2

Page Processing section, 3.2

Page Rendering section, 3.2

Shared Components section, 3.2

pages

about, 3.2

linking to, 4.9

previewing, 4.3.1, 4.5.1, 4.6.3, 4.6.3

running, 4.3.1, 4.5.1, 4.6.3, 4.6.3

password

changing, 3.1

prerequisites

accessing development environment, 2.1

previewing

applications, 4.2.1

pages, 4.3.1, 4.5.1

publishing

URL for application, 5.3

Q

query

modifying, 4.3

Query Builder

about, 3.1

R

Region Definition

editing, 4.6.2

reports, 4.2

addding a column link, 4.9.1

adding, 4.2, 4.5

adding a column, 4.6.2

adding columns from other tables, 4.3

adding links, 4.7

changing column format, 4.6.4

creating a function, 4.6.1

creating conditions, 4.10.1

editing, 4.6

linking to another report, 4.9

making conditional, 4.10

triggers, 4.5

resources

about, 7.2

Advanced Tutorials guide, 7.2

Discussion forum, 7.2

How-to documents, 7.2

Oracle by Example, 7.2

Quick tour, 7.2

training courses, 7.2

Run Application icon, 4.2.1

Run Page icon, 4.2.1, 4.3.1

running

applications, 4.2.1

pages, 4.3.1, 4.5.1

S

sample application

building, 4

sample code

downloading, 7.1, 7.1

sample objects, 3.3

about, 3.3

about Human Resources (HR) schema, 3.3

about Order Entry (OE) schema, 3.3

checking space, 3.3.2.1

deleting, 3.3.2.2

downloading, 3.3.1

importing, 3.3.2

installing, 3.3

viewing, 3.3.3

space

checking available storage, 3.3.2.1

SQL Commands

about, 3.1

SQL Scripts

about, 3.1

storage

checking available, 3.3.2.1

T

themes

about, 4.12

switching, 4.12

triggers

defining, 4.5

U

URL

determining, 5.3

publishing, 5.3

user interface

changing using themes, 4.12

user privileges

about, 1.4

user roles

about, 1.4

developer, 1.4

end user, 1.4

Oracle Application Express administrator, 1.4

workspace administrator, 1.4

users

relationship with schemas, 1.3.1

relationship with workspaces, 1.3.1

users accounts

creating, 2.4

W

workspace administrators

about, 1.4

Workspace home page

about, 3.1

Administration list, 3.1

Application Builder icon, 3.1

Discussion Forum link, 3.1

Links list, 3.1

Oracle Technology Network link, 3.1

SQL Workshop icon, 3.1

User's Guide link, 3.1

Utilities icon, 3.1

Workspace Schemas List, 3.1

workspaces

about, 1.3.1

checking available storage, 3.3.2.1

creating, 2.3.2

relationship with schemas, 1.3.1

requesting space, 3.3.2.1

users, 1.3.1

This illustration shows the series of blocks, or steps, within the Create Application Wizard: Method, Define, and Confirm. Additional information can be found in the surrounding text.

This illustration shows your Employees report with the new theme applied. The new theme uses a green color scheme. The design and layout differ from the previous theme.

This screenshot shows the option for saving the report settings as default being selected.

This picture shows the Filter options from the Actions menu. See surrounding text for further details.

This illustration shows the Regions section located in the Page Rendering area on the Page Definition.

This illustration shows the Employees report for the Executive department. All employees belonging to Department Id = 90 are included.

This screenshot shows the Employees report with the row for Neena highlighted.

This illustration shows the Login section of the Login page with the three fields you need to enter: Workspace, Username, and Password. It shows the example information used in this tutorial, including 2DayPlus for the Workspace name.

This illustration shows developers and workspace administrators accessing the development environment within Application Express. However, the administrator is the only role with access to the Administration Services application. Additional information about this graphic can be found in the surrounding text.

This illustration shows Object Browser. A list of objects appears on the left side of the page. To find a specific object, select its object type at the top of the page. For example, to view tables, select Tables. Additional information about this graphic can be found in the surrounding text.

This illustration shows the first step in the Create Application Wizard. Additional information about this graphic can be found in the surrounding text.

This picture shows the Number of Employees column displayed as a link.

This illustration shows the Create Workspace highlighted on the Manage Workspaces page. Additional information about this graphic can be found in the surrounding text.

This illustration shows the new Departments page. Additional information about this graphic can be found in the surrounding text.

This illustration shows the Run Application icon. It resembles a traffic light with the lights in full color and the green light selected. Additional information about this graphic appears in the surrounding text.

This illustration shows three sections on the Create User page: User Identification, Developer Privileges, and Account Control. Additional information about this graphic can be found in the surrounding text.

This illustration shows the Department select list with Marketing selected. It also shows the details report for Marketing, which shows the number of employees in the department, the manager name, and the location.

This illustration shows the Employees report with the Department Name column included.

This picture shows the Move All icon between the Do Not Display box and the Display in Report box.

This illustration shows the Region section on the Page Definition. Additional information about this graphic can be found in the surrounding text.

This illustration shows an arrow over the Single Row View icon for the first row. See surrounding text for further details.

This illustration shows the Select Columns options. The Remuneration column has just been moved from the Do Not Display box to the DIsplay in Report box.

This illustration shows all columns moved to the Display in Report box and the order they appear on the report: Department Id, Department Name, Number of Employees, Manager Name and Location.

This illustration shows the details page for the first row which is the Marketing Department located in Canada. See surrounding text for further details.

This illustration shows the Departments report that results from the original SQL query.

This picture shows the Controlled Break option available from the column heading link.

This illustration shows the Departments page after all the columns have been specified as columns to be displayed in the report.

This illustration shows the Links list, which contains three links by default: Oracle Technology Network, Discussion Forum, and User's Guide. Additional information about this graphic can be found in the surrounding text.

This illustration shows the list of options available when you click the Actions menu on the running Departments interactive report.

This illustration shows the pages you created in the application as icons, the default view. Additional information about this graphic can be found in the surrounding text.

This illustration shows the first step of the Create Workspace Wizard. It shows the information filled out according to the instructions in this exercise. Additional information about this graphic can be found in the surrounding text.

This illustration shows the Home page of your application. It shows the Home link, the Departments link, and the Developer toolbar at the bottom of the page. Additional information about this graphic can be found in the surrounding text.

This illustration shows the Department select list with No Department Assigned selected. Additional information about this graphic can be found in the surrounding text.

This illustration shows the Employees report after the SQL query has been changed and before the Remuneration column has been added using the Actions menu.

This illustrations shows a sample Page Definition. Each Page Definition contains three areas to organize the page definition information: Page Rendering, Page Processing, and Shared Components. Additional information about this graphic can be found in the surrounding text.

This illustration shows the Create/Edit Employee form you just created. Additional information about this graphic can be found in the surrounding text.

This illustration shows the Employees report with the Remuneration column properly representing dollar amounts. Additional information about this graphic can be found in the surrounding text.

This illustration graphically depicts the architecture of Oracle Application Express when using the Embedded PL/SQL Gateway instead of Oracle HTTP Server (Apache). It shows arrows going in both directions between the Web browser and the Oracle database. The Application Express engine resides within the Oracle database.

This illustration shows the architecture for an instance with a single user. In this case, one user has privileges associated with three roles: Application Express Administrator, Workspace Administrator, and Developer.

This illustration shows the Employees Report with the format changes. The numbers, currency, and dates reflect the formats corresponding to the language setting for the end user's browser. Additional information about this graphic is found in the surrounding text.

This illustration shows the relationship among users, developers, workspaces, and database schemas. Many users and developers can access the same workspace, and one user or developer can access several workspaces. Also, a workspace can be associated with one or more schemas. Additional information about this graphic can be found in the surrounding text.

This illustration shows the report reformatted to include breaks after each location.

This illustration graphically depicts the architecture of Oracle Application Express when using Oracle HTTP Server (Apache) with mod_plsql. The graphic shows arrows going in both directions between the Web browser and the Oracle HTTP Server. It also shows arrows going in both directions between Oracle HTTP Server and the Oracle database. The Application Express engine resides within the Oracle database.

This illustration shows the Departments report with the Department Names displayed in ascending alphabetical order.

This illustration shows the row of icons in the upper right corner, which includes the Run Page icon. The Run Page icon resembles a small, light green traffic light.

This illustration shows the third step in the Create Workspace Wizard. It shows the information filled out according to the instructions in this exercise. Additional information about this graphic can be found in the surrounding text.

This illustration shows the home page for Oracle Application Express Administration Services. These four icons appear on the page: Manage Service, Manage Workspaces, Manage Applications, and Monitor Activity.

This illustration shows the Verification Code section on the Confirmation page when requesting a workspace. It shows a row of buttons across the top: Cancel, Previous, and Submit Request. This illustration also displays the 5-letter verification code hYten. To complete the confirmation process, the user must enter the Verification code that appears in the field provided.

This illustration shows the second step of the Create Workspace Wizard. It shows the information filled out according to the instructions in this exercise. Additional information about this graphic can be found in the surrounding text.

This illustration shows the User Interface section on the Shared Components page. It also shows the options for User Interface with the Themes option highlighted.

This illustration shows the Column Link section properly filled out for this step. Additional information about this graphic can be found in the surrounding text.

This illustration shows two links in the Navigation section: Departments and Employees.

This picture shows the Department Name column sorting order being specified as ascending.

This illustration shows the Success message for creating the page. It also shows two icons: Run Page and Edit Page. The Run Page icon here resembles a traffic light. The Edit Page icon resembles a pencil and some rectangular shapes indicating pages in the application.

This illustration shows the Run Page icon. It resembles a small, light green traffic light. Additional information about this graphic appears in the surrounding text.

This illustration shows the Workspace home page. It shows the three main icons: Application Builder, SQL Workshop, and Utilities. On the right, it shows the default links for a user with the workspace administrator privileges. Additional information about this graphic can be found in the surrounding text.

This illustration shows the Departments report after the Department Id!=60 filter has been applied.

This illustration shows the Select Columns options. The Department Name column has just been moved to the Display in Report box.

This illustration shows the Create Application Wizard after you created the Home page. Additional information about this graphic can be found in the surrounding text.

This illustration shows the settings to enable users to view the application in the language specified in their browser. Additional information about this graphic is found in the surrounding text.

This illustration shows the top corner of the Home page, which now includes the name of your company, AnyCo Corp.

This illustration shows the Employees report. It shows the Remuneration column, which contains numbers without commas (as separators for thousands) and left justified. Additional information about this graphic can be found in the surrounding text.

This illustration shows the Search field, Refresh icon, and the Object list in Object Browser.

Oracle Legal Notices

Copyright Notice

Copyright © 1994-2012, Oracle and/or its affiliates. All rights reserved.

Trademark Notice

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

License Restrictions Warranty/Consequential Damages Disclaimer

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

Warranty Disclaimer

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

Restricted Rights Notice

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle America, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

Hazardous Applications Notice

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Third-Party Content, Products, and Services Disclaimer

This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.

Alpha and Beta Draft Documentation Notice

If this document is in prerelease status:

This documentation is in prerelease status and is intended for demonstration and preliminary use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of this documentation.