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