Preface
Topic Overview
Audience
Documentation Accessibility
Related Documents
Conventions
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
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
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
Building Your Application
About the Application You Build in This Tutorial
Creating the Initial Application
Previewing Your Application
Modifying the Departments Report
Running the Page
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
Displaying Items as Select Lists
Creating Lists of Values
Editing Items to Display as Select Lists
Adding a Link on the Home Page to the Employees Report
Linking the Employees and Departments Reports
Creating a Region
Creating an Item
Linking the Item to the Report
Creating a Branch
Linking a Column Value to Another Page
Adding a Conditional Department Details Report
Creating the Report and Condition
Turning Off Pagination
Adding Your Company Name
Switching Themes to Change the User Interface
About Deploying Your Application
Overview of Deploying Your Application
Creating End Users
About Publishing the Application URL
About Globalization
About Language Identification and Rendering
Specifying the Method for Global Identification
Next Steps
Downloading Public Packaged Applications and Sample Code
Additional Resources
Index