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
  • Running the Page
• Adding an Employees Report and Form
  • Previewing the Pages
• Editing the Employees Report
  • Create a Function
  • Add a New 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 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