• Preface
    • Topic Overview
    • Audience
    • Documentation Accessibility
    • Related Documents
    • Conventions
  • What's New in Oracle Application Express
    • Oracle Application Express Release 3.0 New Features
  • Quick Start
    • What is Oracle Application Express?
    • About Oracle Application Express Architecture
    • Understanding Application Express User Roles
    • Logging In to Oracle Application Express
      • About Browser Requirements
      • Configuring Your Oracle Application Express Environment
      • Logging In to Oracle Application Express as a Developer
        • Requesting a Workspace
        • Logging in to a Workspace
        • Finding Your Workspace Name
        • Resetting Your Password
        • Logging Out of a Workspace
    • About the Workspace Home Page
    • Navigation Alternatives
    • Using Online Help
  • Running a Demonstration Application
    • Installing a Demonstration Application
    • Running an Installed Demonstration Application
      • Running an Application from Demonstration Applications
      • Running an Application from the Application Home Page
    • Understanding Sample Application
      • About the Home Page
      • About the Customers Page
      • About the Products Page
      • About the Orders Page
      • About the Charts Page
      • About the Admin Page
      • Viewing Pages in Printer Friendly Mode
    • Modifying a Demonstration Application
      • About the Developer Toolbar
      • Editing a Demonstration Application
    • Viewing Underlying Database Objects
      • Viewing the Database Object Dependencies Report
      • Viewing Database Objects in Object Browser
  • Application Builder Concepts
    • What Is a Page?
    • Understanding Page Processing and Page Rendering
      • How the Application Express Engine Renders and Processes Pages
      • Understanding Conditional Rendering and Processing
        • Current Page in Expression 1
        • Exists
        • PL/SQL Expression
      • Verifying User Identity
      • Controlling Access to Controls and Components
    • Understanding Session State Management
      • What Is a Session?
      • Understanding Session IDs
      • Viewing Session State
        • About the Session State Page
    • Managing Session State Values
      • Referencing Session State
      • Setting Session State
      • Clearing Session State
        • Clearing Cache by Item
        • Clearing Cache by Page
        • Clearing Cache for an Entire Application
        • Clearing Cache for the Current User Session
      • About Bind Variable Syntax
        • Using Bind Variables in Regions Based on a SQL Query or LOV
        • Using Bind Variables in PL/SQL Procedures
    • Understanding URL Syntax
      • Understanding the URL that Displays for a Page
      • Using f?p Syntax to Link Pages
      • Calling a Page Using an Application and Page Alias
      • Calling a Page from a Button URL
      • Facilitating Bookmarks by Using Zero as the Session ID
    • Understanding Substitution Strings
      • Using Substitution Strings
        • Determining Substitution String Usage within a Given Template
      • About Built-in Substitution Strings
        • APP_ALIAS
        • APP_ID
        • APP_IMAGES
        • APP_PAGE_ID
        • APP_SESSION
        • APP_UNIQUE_PAGE_ID
        • APP_USER
        • AUTHENTICATED_URL_PREFIX
        • BROWSER_LANGUAGE
        • CURRENT_PARENT_TAB_TEXT
        • DEBUG
        • HOME_LINK
        • LOGIN_URL
        • IMAGE_PREFIX
        • Application Express SCHEMA OWNER
        • PRINTER_FRIENDLY
        • LOGOUT_URL
        • PROXY_SERVER
        • PUBLIC_URL_PREFIX
        • REQUEST
        • SQLERRM
        • SYSDATE_YYYYMMDD
        • WORKSPACE_IMAGES
  • Using Application Builder
    • Accessing Application Builder
    • About the Application Builder Home Page
      • Configuring Developer Preferences
    • About the Application Home Page
      • About the Action Bar
        • Run Page Icon
        • Edit Icon
        • Shared Components Icon
        • Developer Comment icon
        • Find Icon
    • About Application Attributes
      • Configuring the Application Definition
        • Accessing the Edit Definition Page
        • About the Edit Definition Page
      • Configuring Security Attributes
        • Accessing the Edit Security Attributes Page
        • About the Security Attributes Page
      • Configuring Globalization Attributes
        • Accessing the Globalization Attributes Page
        • About the Edit Globalization Attributes Page
    • About the Page Definition
      • Accessing a Page Definition
      • Understanding the Page Definition
        • Available Navigation Bar Controls and Buttons
        • About the Action Bar
        • About Page Rendering, Page Processing, and Shared Components
    • Using the View List on the Page Definition
      • Accessing the View List on the Page Definition
      • About Page Events
      • About Database Object Dependencies
      • About History
      • About Export
      • About Groups
      • About Referenced
    • Editing a Page Definition
      • About the Edit All Icon
      • About the Copy or Create Icons
      • Reordering Page Components
      • About Page Rendering
        • Page
        • Regions
        • Buttons
        • Items
        • Computations
        • Processes
      • About Page Processing
        • Computations
        • Validations
        • Processes
        • Branches
      • About Shared Components
        • Tabs
        • Lists of Values
        • Breadcrumbs
        • Lists
        • Theme
        • Templates
        • Security
        • Navigation Bar
      • Understanding Page Computations
        • Creating a Page Computation
        • Understanding Computation Points and Computation Syntax
        • Editing Page Computation Attributes
      • Understanding Validations
        • Creating a Validation
        • Defining How Validation Error Messages Display
        • Processing Validations Conditionally
      • Understanding Page Processes
        • Creating a Page Process
        • Editing Process Attributes
      • Understanding Branches
        • Defining a Branch Point and Action
        • Branching Conditionally
    • Editing Page Attributes
      • Accessing Page Attributes
      • About the Page Attributes Page
        • Name
        • Display Attributes
        • Header and Footer
        • HTML Header
        • HTML Body Attributes
        • Security
        • Duplicate Submission
        • Cache
        • Configuration
        • On Error Text
        • Help
        • Comments
    • About the Developer Toolbar
    • Working with Shared Components
      • Accessing the Shared Components Page
        • Using the Shared Components Icon
      • About the Shared Components Page
        • Application
        • Logic
        • Security
        • Globalization
        • Navigation
        • User Interface
        • Reports
        • Files
      • About Exporting Shared Components
        • Exporting Shared Components from the Export Page
        • Exporting Shared Components from the Shared Components Page
      • Accessing Reports on Shared Components
    • Understanding Application Processes
      • About On Demand Application Processes
        • Running an On Demand Process from a Page Request
      • Application Process Example
      • Creating an Application Process
        • About the Application Process Page
      • Accessing Application Processes Reports
        • Utilization
        • History
    • Understanding Application Computations
      • About Application Computations
        • About Application Computations that Execute On New Instance
      • Creating an Application Computation
        • About the Application Computations Page
      • Accessing the Application Computation History Report
    • Viewing Application Reports
      • Accessing Application Reports
      • Shared Components Reports
        • About the Database Object Dependencies Report
      • Page Components Reports
        • About the Search Region Source Report
      • Activity Reports
        • About the Page Views by Hour Report
      • Cross Application Reports
        • About the Application Comparison Report
  • Building an Application
    • Creating an Application
      • About Creating an Application Using a Wizard
      • About the Create Application Wizard
        • Creating an Application Based on Tables or Queries
        • About Application Models and User Interface Defaults
        • Leveraging Application Models and User Interface Defaults
      • About the Create Application from Spreadsheet Wizard
      • About Demonstration Applications
        • Accessing Demonstration Applications
      • Copying an Application
      • Deleting an Application
        • Deleting an Application from Application Builder
        • Deleting an Application from the Edit Definition Page
    • Managing Pages in an Application
      • About Creating Pages
      • Creating a Page from the Application Home Page
      • Creating a Page from the Page Definition
        • About Create Page Types
      • Creating a Page from the Developer Toolbar
      • Copying a Page
      • Running a Page or Application
        • About the Run Application and Run Page Icons
        • Running an Application from the Application Builder Home Page
        • Running an Application from the Application Home Page
        • Running a Page on the Application Home Page
        • Running a Page from the Page Definition
      • Grouping Pages
        • Viewing the Page Groups
        • Creating a Page Group
        • Assigning a Page to a Page Group
        • Removing a Page from a Page Group
        • Removing a Page Group
        • Viewing the Pages by Page Group Report
      • Locking and Unlocking a Page
        • Determining If a Page Is Locked
        • Locking a Page
        • Unlocking Pages
        • Accessing Alternative Locked Pages Views
      • Deleting a Page
        • Deleting a Page from the Page Definition
        • Deleting a Page While Editing Page Attributes
    • Adding Application Comments
      • Creating an Application Comment
      • Viewing the Application Comments Report
    • Adding Developer Comments
      • Adding Developer Comments to an Application or Page
      • Viewing and Editing Developer Comments
        • About the Navigation Bar on the View Comments Page
      • Deleting Developer Comments
        • Deleting a Specific Developer Comment
        • Deleting Multiple Developer Comments
      • About the Developer Comments Report
        • Accessing the Developer Comments Report
        • Editing Comments from the Developer Comments Report
        • Deleting a Comment from the Developer Comments Report
        • Deleting Multiple Comments from the Developer Comments Report
        • Downloading the Developer Comments Report
    • Creating Reports
      • Creating a Report Using a Wizard
      • Editing Report Attributes
        • Accessing the Report Attributes Page
        • About Navigation Alternatives
      • Altering Report Layout Using Column Attributes
      • Controlling Report Pagination
        • Accessing and Understanding Layout and Pagination Attributes
        • Including Pagination After the Rows in a Report
        • Including Pagination Before the Rows in a Report
      • Enabling Column Sorting
      • Adding a Download Link to a Report
        • Enabling the CSV Output Option
      • Exporting a Report as an XML File or a CSV File
      • Creating a Column Link
      • Defining an Updatable Column
      • Defining a Column as a List of Values
      • Controlling When Columns Display
      • Controlling Column Breaks
      • Configuring Printing for Reports
        • About Report Layouts
        • Creating Report Queries
        • Creating Report Layouts
        • Overview of Printing Report Regions
        • Configuring Print Attributes for Report Regions
    • Creating Forms
      • Creating a Form Using a Wizard
      • Creating a Tabular Form
      • Creating a Master Detail Form
      • Creating a Form Manually
        • Processing a Form
        • Creating an Automatic Row (DML) Processing Process
        • Creating a Process that Contains One or More Insert Statements
        • Using a PL/SQL API to Process Form Values
        • Populating Forms
      • Validating User Input in Forms
        • Creating a Validation
        • Associating a Validation with a Specific Item
        • About Error Message
    • Creating Calendars
      • About Creating Calendars
        • Supported Calendar Substitution Strings
      • Creating a New Calendar
        • Adding a Calendar to an Existing Page
        • Adding a Calendar to a New Page
      • Editing a Calendar Title
      • Editing Calendar Attributes
        • Accessing the Calendar Attributes Page
        • About the Calendar Attributes Page
      • Upgrading a Calendar Created in a Previous Releases
      • Converting an Easy Calendar to a SQL Calendar
    • Creating Charts
      • About Supported Chart Types
        • About Flash Charts
        • About SVG Plug-in Support
      • About Creating SQL Queries for Charts
      • Creating an HTML Chart
        • Adding an HTML Chart to an Existing Page
        • Adding an HTML Chart to a New Page
      • Creating a SVG Chart
        • Adding a SVG Chart to an Existing Page
        • Adding a SVG Chart to a New Page
        • About SVG Chart Types
        • Understanding SVG Chart Cascading Style Sheet Classes
        • Referencing a Custom SVG Chart Cascading Style Sheet
        • Specifying Custom CSS Styles Inline for SVG Charts
      • Creating a Flash Chart
        • Adding a Flash Chart to an Existing Page
        • Adding a Flash Chart to a New Page
        • About Migrating SVG Charts to Flash
      • Editing Chart Attributes
        • About Navigation Alternatives
      • Using Custom XML with Flash Charts
      • Enabling Asynchronous Updates
      • Displaying SVG Charts in Other Languages
    • Creating Buttons
      • About the Buttons Section of the Page Definition
      • Creating a Button Using a Wizard
        • Creating an HTML Button
      • Creating Multiple Buttons
      • Editing Buttons
        • Editing Button Attributes
        • Using the Edit All Icon to Edit Multiple Buttons
        • Using the Reorder Buttons Icon
      • Understanding the Relationship Between Button Names and REQUEST
      • About Branching with Buttons
      • Displaying Buttons Conditionally
    • Understanding Page-Level Items
      • Differences Between Page Items and Application Items
      • About the Items Section of the Page Definition
        • About the Drag and Drop Icon
        • About the Reorder Items Icon
      • Creating Page-Level Items
        • Creating a Page-Level Item on the Page Definition
        • About Item Naming Conventions
        • About Item Types
        • Creating Multiple Items Using Tabular Form
        • Creating Multiple Items Using Drag and Drop
        • Creating a Static List of Values
      • Editing Page-Level Items
        • Editing Page Item Attributes
        • Using the Edit All Icon to Edit Multiple Items
        • Using the Reorder Region Items Icon
      • Using the Drag and Drop Layout Page
        • Accessing the Drag and Drop Layout Page
        • About the Drag and Drop Layout Page
        • Creating a New Item
        • Editing Existing Items
        • Deleting Items
      • Referencing Item Values
      • Displaying Conditional or Read-Only Page Items
      • Working with a Multiple Select List Item
        • Using APEX_UTIL.STRING_TO_TABLE to Convert Selected Values
      • Populating an Alternative Date Picker Format for an Application
        • Defining PICK_DATE_FORMAT_MASK as an Application Substitution String
        • Defining an Application-Level Item Named PICK_DATE_FORMAT_MASK
      • Populating an Alternative Date Picker Format for a Specific Item
    • Understanding Application-Level Items
      • Creating an Application-level Item
        • About the Application Items Page
      • Accessing Application Item History
      • Editing Application-level Item Attributes
        • About Navigation Alternatives
    • Creating Lists of Values
      • Creating a Named LOV at the Application Level
        • About the List of Values Page
      • About Static LOVs
      • Editing an Existing LOV
        • About Navigation Alternatives
        • Bulk Edit of Static LOVs
      • Referencing Session State Within an LOV
      • Referencing a Null Value in an Item Based on an LOV
      • Accessing LOV Reports
        • Search
        • Subscription
        • Utilization
        • History
    • Creating Dependent Select Lists
    • Using Shortcuts
      • About Shortcut Types
        • Text with JavaScript Escaped Single Quotes
        • Message
        • Message with JavaScript Escaped Single Quotes
      • Defining Shortcuts
        • About the Shortcuts Page
      • Editing Existing Shortcuts
        • About Navigation Alternatives
      • Accessing Shortcut Reports
        • Subscribed Shortcuts
        • Shortcut History
    • Using the Find Icon
      • About the Find Icon
      • About the Item Finder
      • Using the Page Finder
      • Using the Query Finder
      • Using the Table Finder
      • Using the PL/SQL Finder
      • Using the Images Finder
      • Using the CSS Finder
    • Controlling Access to Applications, Pages, and Page Components
      • How the Access Control List Works
      • Creating an Access Control List
        • Creating an Access Control from the Application Home Page
        • Creating an Access Control from the Page Definition
        • Creating an Access Control List from the Developer Toolbar
      • Selecting an Application Mode and Adding Users
        • Selecting an Application Mode
        • Adding Users to the Access Control List and Selecting Privileges
        • Removing Users from the Access Control List
      • Controlling Access for Pages and Page Components
    • Incorporating JavaScript into an Application
      • Referencing Items Using JavaScript
      • Incorporating JavaScript Functions
        • Incorporating JavaScript into the HTML Header Attribute
        • Including JavaScript in a .js File Referenced by the Page Template
      • Calling JavaScript from a Button
    • Creating a Help Page
      • Creating a Help Page and Region
      • Defining Help Text
        • Defining Help for a Page
        • Defining Help Text for an Item
        • Editing Multiple Item Help Topics Simultaneously
      • Creating a Help Navigation Bar Entry
  • Adding Navigation
    • Creating Tabs
      • About Template Support
      • About the Tabs Section of the Page Definition
      • Using the Reorder Tabs Icon
      • About the Tabs Page
      • How to Create a Tab
      • Editing Tabs
        • Editing Multiple Tabs Simultaneously
        • Using the Standard Tab Task List
      • Accessing Tab Reports
        • Standard Tab Utilization
        • Standard and Parent Tab History
    • Creating Lists
      • How To Create a List
        • Creating a List from Scratch
        • Copying Lists
        • Adding List Entries and Sublists
        • Changing Parents of List Entries
        • Removing Parent of Orphaned List Entries
      • Adding a List to a Page
      • Editing a List
      • Editing Multiple List Entries Simultaneously
      • Accessing List Reports
        • Utilization
        • Unused
        • History
    • Creating Breadcrumbs
      • About Breadcrumbs
      • How to Create Breadcrumbs
        • Creating a Breadcrumb While Creating a Page
        • Creating a Breadcrumb Manually
      • Editing Breadcrumbs
        • About Navigation Alternatives
      • Reparenting Breadcrumb Entries
      • Accessing Breadcrumb Reports
        • Breadcrumb Utilization Report
        • Breadcrumb History Report
    • Creating Trees
      • How To Create a Tree
      • Editing a Tree
        • About Navigation Alternatives
      • Accessing Tree Reports
        • Tree Utilization
        • Tree History
    • Creating a Navigation Bar Entry
      • About Navigation Bars
      • How to Create a Navigation Bar Entry
      • Editing a Navigation Bar Entry
      • Editing Multiple Navigation Bar Entries Simultaneously
      • Using the Reorder Navigation Bar Entries Icon
      • Accessing Navigation Bar Entry Reports
        • Navigation Bar Entry Subscription Report
        • Navigation Bar Entry History
    • Controlling Navigation Using Branches
  • Controlling Page Layout and User Interface
    • Understanding Page Layout in Oracle Application Express
    • Displaying Components on Every Page of an Application
    • Understanding Regions
      • About the Regions Section of the Page Definition
      • Using the Reorder Regions Icon
      • Editing Region Attributes
        • Editing a Region Definition
        • How Region Attributes Affect Page Layout
        • Specifying a Region Header and Footer
        • Enabling Users to Customize a Page
        • Utilizing Region Caching
        • Specifying a Static Region ID
      • Creating a Region
      • About Region Types
      • Copying a Region
    • Creating a Multiple Column Layout
      • Creating Regions in Multiple Columns
      • Creating a Multiple Column Page Template
    • How Item Attributes Affect Page Layout
    • Incorporating Content from Other Web Sites
    • Managing Themes
      • Accessing the Themes Page
        • Accessing the Themes Page from Shared Components
        • Accessing the Themes Page from a Page Definition
      • Changing the Default Templates in a Theme
      • Creating a New Theme
        • About the Themes Page
      • Switching the Active Theme
      • Copying a Theme
      • Deleting a Theme
      • About Exporting and Importing Themes
      • Changing a Theme Identification Number
      • Viewing Theme Reports
        • Viewing All Templates in a Theme
        • Viewing Theme Template Counts
        • Viewing File References
        • Viewing Class References
        • Viewing Template Substitution Strings
    • Customizing Templates
      • About Cascading Style Sheets
      • Selecting a Default Page Template
        • Selecting a Page-level Template Within a Theme
        • Selecting a Page-level Template for a Specific Page
      • Creating a New Template
      • Viewing Template Reports
      • Editing Templates
        • Viewing Templates on the Templates Page
        • Viewing Templates Associated with a Specific Page
      • Breadcrumb Templates
        • About Breadcrumb Style Navigation
        • Breadcrumb Template Attributes
      • Button Templates
        • Button Template Attributes
      • Calendar Templates
        • Calendar Template Attributes
      • Label Templates
        • Label Template Attributes
      • List Templates
        • About Hierarchical Lists
        • List Template Attributes
      • Page Templates
        • Supported Page Template Substitution Strings
        • Page Template Attributes
      • Popup LOV Templates
        • Popup List of Values Template Attributes
      • Region Templates
        • Region Template Attributes
      • Report Templates
        • About Generic Column Templates and Named Column Templates
        • Report Column Template Attributes for Generic Column Templates
        • Report Column Template Attributes for Named Column Templates
        • About Using JavaScript in Column Templates
    • Optimizing a Page for Printing
      • Selecting a Printer Friendly Template for an Application
      • Using f?p Syntax to Toggle to Printer Friendly Mode
    • Using Custom Cascading Style Sheets
      • Uploading Cascading Style Sheets
        • About the Cascading Style Sheets Page
      • Referencing an Uploaded Cascading Style Sheet in the Page Template
    • Managing Images
      • Uploading Images
      • Referencing Images
        • Verifying the Prefix for the Virtual Image Directory
        • Referencing an Image Using #IMAGE_PREFIX#
        • Referencing Images Using a Fully Qualified URL
      • Editing Image Attributes
      • Deleting an Image
    • Managing Static Files
      • Uploading Static Files
      • Editing an Uploaded File
      • Downloading an Uploaded File
      • Deleting an Uploaded File
    • Rendering HTML Using Custom PL/SQL
  • Understanding Application Administration
    • Understanding Administrator Roles
    • About the Application Administration Page
      • Accessing the Application Administration Page
      • Resetting Your Password from Application Administration
      • Viewing the Application Express Product Information Page
    • About the Manage Services Page
      • Accessing the Manage Services Page
    • Managing Session State and User Preferences
      • Managing Session State
        • Removing Session State After Reviewing Session Details
        • Viewing Session State Details
        • Purging Session State for the Current Session
        • Purging Sessions by Age
      • Managing User Preferences
        • Viewing and Resetting Preferences for the Current User
        • Viewing Preferences for Users
        • Setting User Preferences
        • Removing User Preferences Programatically
        • Resetting User Preferences Using a Page Process
        • Purging Preferences for a Specific User
    • Managing Cached Regions and Pages
      • Purging Cached Regions
      • Purging Cached Pages
    • Managing Workspace Preferences
      • Disabling PL/SQL Program Unit Editing for a Workspace
      • Enabling Login Controls for a Workspace
    • Managing Application Models
      • Deleting an Application Model
    • Managing Demonstration Applications
    • Leveraging Application Builder Defaults
      • About Application Builder Defaults
      • Configuring Application Builder Defaults
    • Viewing the Workspace Overview Report
      • Viewing Workspace Summary Report
      • Viewing Available Storage Space
    • Terminating a Workspace Service
    • Requesting a Database Schema
    • Requesting Additional Storage
    • Viewing Schema Reports
    • Managing Log Files
      • Purging the Developer Activity Log
      • Purging the External Click Count Log
    • Managing Application Express Users
      • Creating New User Accounts
      • Editing Existing User Accounts
      • Deleting or Locking User Accounts
      • Changing an End User Password
      • Using Groups to Manage Application Express Users
        • Creating a Group
        • Editing an Existing User Group
        • Viewing Group Assignment Reports
        • Adding Users to a Group
        • Removing Users from a Group
    • Monitoring Activity within a Workspace
      • Viewing Developer Activity and Application Change Information
      • Viewing Application Changes by Developer
      • Viewing Application Changes by Day
      • Viewing Active Sessions
  • Managing User Interface Defaults
    • Viewing Tables or Views Utilizing User Interface Defaults
      • Creating to User Interface Defaults
      • Viewing the UI Defaults Report in Object Browser
    • Editing Column Attributes
      • About the Column Definition
        • Label Default
        • Report Defaults
        • Tabular Form Default
        • Form Defaults
      • About List of Values
      • About the Database Column Definition Report
    • Comparing User Interface Defaults Across Applications
    • About Exporting and Importing User Interface Defaults
  • Debugging an Application
    • About Tuning Performance
    • Reviewing Session State
    • Accessing Debug Mode
    • Enabling SQL Tracing and Using TKPROF
    • Monitoring Application and Page Resource Use
    • Viewing Reports
    • Debugging Problematic SQL Queries
    • Removing Controls and Components to Isolate a Problem
  • Managing Application Security
    • About Cross-Site Scripting Protection
      • Protecting HTML Regions and Other Static Areas
        • About Safe Item Display Types
        • About the Rules Used to Determine Whether to Escape Values
        • Using Safe Item Types to Hold and Emit HTML Markup
      • Protecting Dynamic Output
      • Protecting Report Regions
      • Protecting Form Items
    • Enabling Network Services in Oracle Database 11g
    • Understanding Session State Protection
      • How Session State Protection Works
      • Enabling Session State Protection
        • Enabling Session State Protection from Edit Security Attributes
        • Enabling Session State Protection from Session State Protection
      • Configuring Session State Protection
        • Reviewing Existing Session State Protection Settings
        • Configuring Session State Protection Using a Wizard
        • Configuring Session State Protection for Pages
        • Configuring Session State Protection for Items
        • Configuring Session State Protection for Application Items
    • Understanding the Security Risks of File Upload Tables
    • Establishing User Identity Through Authentication
      • Understanding How Authentication Works
      • Determining Whether to Include Authentication
      • About Preconfigured Authentication Schemes
        • Application Express Account Credentials
        • Database Account Credentials
        • LDAP Credentials Verification
        • DAD Credentials Verification
        • About Single Sign-On Server Verification
      • Creating an Authentication Scheme
      • Using the Authentication Scheme Repository
      • Viewing the Current Authentication Scheme for an Application
      • Changing the Current Authentication Scheme for an Application
      • Viewing Authentication Scheme Utilization
      • About Creating an Authentication Scheme from Scratch
        • About Session Management Security
        • Building a Login Page
        • About Deep Linking
    • Providing Security Through Authorization
      • How Authorization Schemes Work
      • Creating an Authorization Scheme
        • Editing Attributes of an Existing Authorization Scheme
        • About the Evaluation Point Attribute
        • About Resetting Authorization Scheme State
      • Attaching an Authorization Scheme to an Application, Page, or Components
        • Attaching an Authorization Scheme to an Application
        • Attaching an Authorization Scheme to a Page
        • Attaching an Authorization Scheme to a Control or Component
      • Viewing Authorization Reports
        • Subscription
        • Utilization
  • Deploying an Application
    • About the Oracle Application Express Application Development Life Cycle
      • System Development Life Cycle Methodologies to Consider
    • Understanding the Packaging Process
      • Deployment Options to Consider
      • Deciding Whether to Copy a Workspace
      • Deciding Whether to Copy a Database
      • About the Application ID
      • Deciding to Install a New HTTP Server
    • How to Move an Application to Another Development Instance
      • About Managing Database Objects
    • How to Create a Packaged Application
      • How a Packaged Application Simplifies Deployment
      • Creating a Packaged Application
        • Accessing the Supporting Objects Page
        • About the Supporting Objects Page
      • Adding Installation Scripts for an Image, Cascading Style Sheet, or Static File
      • Adding an Access Control List to a Packaged Application
      • Installing Supporting Objects
      • Deleting Supporting Objects Scripts, Messages, and Installation Options
      • Upgrading a Packaged Application
        • Defining an Upgrade Script
        • Upgrading a Packaged Application
      • Deinstalling Supporting Objects
      • Viewing an Install Summary
    • Exporting an Application and Related Files
      • Exporting an Application
      • Exporting Workspace Users
      • Exporting Application Components
      • Exporting a Page in an Application
      • Exporting Cascading Style Sheets
      • Exporting Images
      • Exporting Static Files
        • About Importing into Another Oracle Application Express Instance
      • Exporting Script Files
      • Exporting Themes
        • Exporting a Theme from the Export Page
        • Exporting a Theme from the Themes Page
      • Exporting User Interface Defaults
        • Exporting User Interface Defaults from the Export Page
        • Exporting User Interface Defaults from the User Interface Defaults Page
    • Importing Export Files
      • Importing an Application or Page
      • Importing Cascading Style Sheets
      • Importing Static Files
      • Importing Images
      • Importing Themes
      • Importing User Interface Defaults
    • Installing Export Files
      • Accessing the Export Repository
      • Installing an Application Export from the Export Repository
        • About Installing a Packaged Application
      • Installing Other Files from the Export Repository
      • Deleting Files from the Export Repository
      • Installing Export Files from SQL*Plus
        • Verifying If Source and Target Workspace IDs Are Identical
        • Using SQL*Plus to Install Export Files
    • About Publishing the Application URL
    • Using Build Options to Control Configuration
      • Creating Build Options
        • About the Build Options Page
      • Managing Build Options
        • Selecting a Build Option
      • Exporting Build Options or Build Option Status
      • Viewing the Build Option Utilization Report
  • Advanced Programming Techniques
    • About DML Lockings
    • Accessing Data with Database Links
    • Sending Email from an Application
      • About Configuring Oracle Application Express to Send Email
      • Sending Email from an Application
    • Using Collections
      • About the APEX_COLLECTION API
        • About Collection Naming
      • Creating a Collection
        • About the Parameter p_generate_md5
      • Truncating a Collection
      • Accessing a Collection
      • Deleting a Collection
        • Deleting All Collections for the Current Application
        • Deleting All Collections in the Current Session
      • Adding Members to a Collection
        • About the Parameters p_generate_md5 and p_clob001
      • Updating Collection Members
      • Deleting Collection Members
      • Determining Collection Status
      • Merging Collections
      • Managing Collections
        • Obtaining a Member Count
        • Resequencing a Collection
        • Verifying Whether a Collection Exists
        • Adjusting a Member Sequence ID
        • Sorting Collection Members
      • Clearing Collection Session State
    • Creating Custom Activity Reports Using APEX_ACTIVITY_LOG
    • Running Background PL/SQL
      • Understanding the APEX_PLSQL_JOB Package
      • About System Status Updates
      • Using a Process to Implement Background PL/SQL
    • Implementing Web Services
      • Understanding Web Service References
        • Accessing the Web Service References Page
        • Specifying an Application Proxy Server Address
      • Working with SSL Enabled Web Services
      • Creating a Web Service Reference Based on a WSDL
        • Creating a Web Service Reference by Searching a UDDI Registry
        • Creating a Web Service Reference by Specifying a WSDL Document
        • Creating a Web Service Manually
      • Using the Web Service Reference Repository
      • Testing a Web Service Reference Created from a WSDL
      • Testing a Web Service Reference Created Manually
      • Creating an Input Form and Report on a Web Service
        • Creating a Form and Report After Creating a Reference
        • Creating a Form and Report by Adding a New Page
      • Creating a Form on a Web Service
        • Creating a Form After Creating a Reference
        • Creating a Form by Adding a New Page
      • Invoking a Web Service as a Process
        • Displaying Web Service Results in a Report
      • Editing a Web Service Process
      • Viewing a Web Service Reference History
  • Managing Application Globalization
    • About Translating an Application and Globalization Support
      • About Language Identification
      • Rules for Translating Applications Built in Application Builder
      • How Translated Applications Are Rendered
      • About Translatable Components
        • About Shortcuts that Support Translatable Messages
        • About Messages
        • About Dynamic Translation Text Strings
        • About Translating Region Titles
        • About Translating Templates
    • Specifying the Primary Language for an Application
      • Using Format Masks for Items
      • Translating Applications for Multibyte Languages
    • Understanding the Translation Process
      • Step 1: Map the Target Language
      • Step 2: Seed and Export Text to a Translation File
        • Seeding Translatable Text
        • Exporting Text to a Translation File
      • Step 3: Translate the XLIFF File
      • Step 4: Upload and Apply a Translated XLIFF Document and Publish the Application
        • Uploading a Translated XLIFF Document
        • Applying an Uploaded XLIFF Document and Publishing an Application
        • Deleting an Uploaded XLIFF Document
      • Manually Editing a Translation
    • Translating Messages
      • Translating Messages Used in PL/SQL Procedures
        • About the APEX_LANG.MESSAGE API
      • Translating Messages Used Internally by Application Express
    • Translating Data That Supports List of Values
      • Defining a Dynamic Translation
      • APEX_LANG.LANG API
    • About Supported Globalization Codes
  • Oracle Application Express APIs
    • APEX_UTIL
      • CHANGE_CURRENT_USER_PW Procedure
      • CACHE_GET_DATE_OF_PAGE_CACHE Procedure
      • CACHE_PURGE_BY_APPLICATION Procedure
      • CACHE_PURGE_BY_PAGE Procedure
      • CACHE_PURGE_STALE Procedure
      • CHANGE_PASSWORD_ON_FIRST_USE Function
      • CLEAR_APP_CACHE Procedure
      • CLEAR_PAGE_CACHE Procedure
      • CLEAR_USER_CACHE Procedure
      • COUNT_CLICK Procedure
      • COUNT_STALE_REGIONS Function
      • CREATE_USER Procedure
      • CREATE_USER_GROUP Procedure
      • CURRENT_USER_IN_GROUP Function
      • EDIT_USER Procedure
      • END_USER_ACCOUNT_DAYS_LEFT Function
      • EXPIRE_END_USER_ACCOUNT Procedure
      • EXPIRE_WORKSPACE_ACCOUNT Procedure
      • EXPORT_USERS Procedure
      • FETCH_APP_ITEM Function
      • FETCH_USER Procedure
      • FIND_SECURITY_GROUP_ID Function
      • FIND_WORKSPACE Function
      • GET_ACCOUNT_LOCKED_STATUS Function
      • GET_ATTRIBUTE Function
      • GET_AUTHENTICATION_RESULT Function
      • GET_CURRENT_USER_ID Function
      • GET_DEFAULT_SCHEMA Function
      • GET_EMAIL Function
      • GET_FILE Procedure
      • GET_FILE_ID Function
      • GET_FIRST_NAME Function
      • GET_GROUPS_USER_BELONGS_TO Function
      • GET_GROUP_ID Function
      • GET_GROUP_NAME Function
      • GET_LAST_NAME Function
      • GET_USERNAME Function
      • GET_NUMERIC_SESSION_STATE Function
      • GET_PREFERENCE Function
      • GET_SESSION_STATE Function
      • GET_USER_ID Function
      • GET_USER_ROLES Function
      • IS_LOGIN_PASSWORD_VALID Function
      • IS_USERNAME_UNIQUE Function
      • KEYVAL_NUM Function
      • KEYVAL_VC2 Function
      • LOCK_ACCOUNT Procedure
      • PASSWORD_FIRST_USE_OCCURRED Function
      • PREPARE_URL Function
      • PUBLIC_CHECK_AUTHORIZATION Function
      • PURGE_REGIONS_BY_APP Procedure
      • PURGE_REGIONS_BY_ID Procedure
      • PURGE_REGIONS_BY_NAME Procedure
      • PURGE_REGIONS_BY_PAGE Procedure
      • PURGE_STALE_REGIONS Procedure
      • REMOVE_PREFERENCE Procedure
      • REMOVE_SORT_PREFERENCES Procedure
      • REMOVE_USER Procedure
      • RESET_AUTHORIZATIONS Procedure
      • RESET_PW Procedure
      • SAVEKEY_NUM Function
      • SAVEKEY_VC2 Function
      • SET_ATTRIBUTE Procedure
      • SET_AUTHENTICATION_RESULT Procedure
      • SET_CUSTOM_AUTH_STATUS Procedure
      • SET_EMAIL Procedure
      • SET_FIRST_NAME Procedure
      • SET_LAST_NAME Procedure
      • SET_PREFERENCE Procedure
      • SET_SESSION_STATE Procedure
      • SET_USERNAME Procedure
      • STRING_TO_TABLE Function
      • TABLE_TO_STRING Function
      • UNEXPIRE_END_USER_ACCOUNT Procedure
      • UNEXPIRE_WORKSPACE_ACCOUNT Procedure
      • UNLOCK_ACCOUNT Procedure
      • URL_ENCODE Function
      • WORKSPACE_ACCOUNT_DAYS_LEFT Function
    • APEX_MAIL
      • SEND Procedure
      • PUSH_QUEUE Procedure
    • APEX_ITEM
      • CHECKBOX Function
      • DATE_POPUP Function
      • DISPLAY_AND_SAVE Function
      • HIDDEN Function
      • MD5_CHECKSUM Function
      • MD5_HIDDEN Function
      • MULTI_ROW_UPDATE Procedure
      • POPUP_FROM_LOV Function
      • POPUP_FROM_QUERY Function
      • POPUPKEY_FROM_LOV Function
      • POPUPKEY_FROM_QUERY Function
      • RADIOGROUP Function
      • SELECT_LIST Function
      • SELECT_LIST_FROM_LOV Function
      • SELECT_LIST_FROM_LOV_XL Function
      • SELECT_LIST_FROM_QUERY Function
      • SELECT_LIST_FROM_QUERY_XL Function
      • TEXTAREA Function
      • TEXT Function
      • TEXT_FROM_LOV Function
      • TEXT_FROM_LOV_QUERY Function
    • APEX_APPLICATION
      • Referencing Arrays
      • Referencing Values Within an On Submit Process
      • Converting an Array to a Single Value
    • APEX_CUSTOM_AUTH
      • APPLICATION_PAGE_ITEM_EXISTS Function
      • CURRENT_PAGE_IS_PUBLIC Function
      • DEFINE_USER_SESSION Procedure
      • GET_COOKIE_PROPS Procedure
      • GET_LDAP_PROPS Procedure
      • GET_NEXT_SESSION_ID Function
      • GET_SESSION_ID_FROM_COOKIE Function
      • GET_USERNAME Function
      • GET_SECURITY_GROUP_ID Function
      • GET_SESSION_ID Function
      • GET_USER Function
      • IS_SESSION_VALID Function
      • LOGIN Procedure
      • LOGOUT Procedure
      • POST_LOGIN Procedure
      • SESSION_ID_EXISTS Function
      • SET_USER Procedure
      • SET_SESSION_ID Procedure
      • SET_SESSION_ID_TO_NEXT_VALUE Procedure
    • APEX_LDAP
      • AUTHENTICATE Function
      • IS_MEMBER Function
      • MEMBER_OF Function
      • MEMBER_OF2 Function
      • GET_USER_ATTRIBUTES Procedure
      • GET_ALL_USER_ATTRIBUTES Procedure
  • Managing Database Objects with Object Browser
    • About Object Browser
      • Accessing Object Browser
    • Searching For and Browsing Database Objects
      • Searching For and Selecting Database Objects
      • Hiding the Object Selection Pane
      • Using the Find Tables Icon
    • About Creating New Database Objects
    • Managing Tables
      • Creating a Table
      • Browsing a Table
        • Summary of Available Views
      • Editing a Table
      • Dropping a Table
    • Managing Views
      • Creating a View
      • Browsing a View
        • Summary of Available Views
      • Editing a View
        • Editing a View Manually
        • Using Find and Replace
        • Downloading a View
      • Compiling a View
      • Dropping a View
    • Managing Indexes
      • Creating an Index
      • Browsing an Index
        • Summary of Available Views
      • Dropping an Index
    • Managing Sequences
      • Creating a Sequence
      • Browsing a Sequence
        • Summary of Available Views
      • Dropping a Sequence
    • Managing Types
      • Creating a Type
      • Browsing a Type
        • Summary of Available Views
      • Dropping a Type
    • Managing Packages
      • Creating a Package
      • Viewing a Package
        • Summary of Available Views
      • Editing a Package
        • Editing a Package Manually
      • Compiling a Package
      • Downloading a Package
      • Dropping a Package
    • Managing Procedures
      • Creating a Procedure
      • Browsing a Procedure
        • Summary of Available Views
      • Editing a Procedure
        • Editing a Procedure Manually
      • Compiling a Procedure
      • Downloading a Procedure
      • Dropping a Procedure
    • Managing Functions
      • Creating a Function
      • Browsing a Function
        • Summary of Available Views
      • Editing a Function
        • Editing a Function Manually
      • Compiling a Function
      • Downloading a Function
      • Dropping a Function
    • Managing Triggers
      • Creating Triggers
      • Browsing a Trigger
        • Summary of Available Views
      • Editing a Trigger
        • Editing a Trigger Manually
      • Compiling a Trigger
      • Downloading a Trigger
      • Dropping a Trigger
    • Managing Database Links
      • Creating a Database Link
      • Browsing a Database Link
        • Summary of Available Views
      • Dropping a Database Link
    • Managing Materialized Views
      • Creating a Materialized View
      • Browsing a Materialized View
        • Summary of Available Views
      • Dropping a Materialized View
    • Managing Synonyms
      • Creating Synonyms
      • Viewing a Synonym
      • Dropping a Synonym
  • Building Queries with Query Builder
    • About Query Builder
      • Accessing Query Builder
      • Understanding the Query Building Process
    • Using the Object Selection Pane
      • Searching and Filtering Objects
      • Hiding the Object Selection Pane
    • Selecting Objects
      • About Supported Column Types
      • Adding an Object to the Design Pane
        • Resizing the Design and Results Panes
      • Removing or Hiding Objects in the Design Pane
    • Specifying Query Conditions
    • Creating Relationships Between Objects
      • About Join Conditions
      • Joining Objects Manually
      • Joining Objects Automatically
    • Working with Saved Queries
      • Saving a Query
      • Editing a Saved Query
      • Deleting a Saved Query
    • Viewing Generated SQL
    • Viewing Query Results
  • Using SQL Scripts
    • What is SQL Scripts?
    • Accessing SQL Scripts
      • About the SQL Scripts Page
    • Creating a SQL Script
      • Creating a SQL Script in the Script Editor
      • Uploading a SQL Script
    • Using the Script Editor
      • Editing an Existing Script
      • Searching and Replacing Text or Regular Expressions
      • Summary of Script Editor Controls
    • Deleting a SQL Script
      • Deleting Scripts from the SQL Scripts Page
      • Deleting a Script in the Script Editor
    • Copying a SQL Script
    • Executing a SQL Script
      • Executing a SQL Script in the Script Editor
      • Executing a SQL Script from the SQL Scripts Page
      • About the Run Script Page
    • Viewing SQL Script Results
      • Viewing Results from the SQL Scripts Page
      • About the Results Page
    • Exporting and Importing SQL Scripts
      • Copying Scripts to an Export Script
        • About the Scripts Pane
        • About the Scripts to Export Pane
      • Importing Scripts from an Export Script
        • About the Import Scripts Pane
    • Viewing Script and Result Quotas
  • Using SQL Commands
    • What is SQL Commands?
    • About the SQL Workshop Page
    • Accessing SQL Commands
    • About the SQL Commands Home Page
    • Using the Command Editor
      • Running a SQL Command
      • About Transactions in SQL Commands
      • About Unsupported SQL*Plus Commands
      • About Command Termination
      • Using Bind Variables
    • Saving a SQL Command
    • Copying a Command
    • Using Saved Commands
      • Accessing Saved Commands
      • About the Saved SQL Pane
    • Using SQL Command History
      • Accessing a Command from Command History
      • About the History Pane
    • Viewing Results
      • Accessing the Results Pane
      • About the Results Pane
    • Using Explain Plan
      • Viewing an Explain Plan
      • About Explain Plan Pane
  • Using Application Express Utilities
    • About Importing, Exporting, Loading, and Unloading Data
      • Choosing the Right Import/Export/Load/Unload Option
    • Loading and Unloading Data from the Database
      • Accessing the Data Load/Unload Page
      • Loading Data
        • Loading a Text File
        • Loading Spreadsheet Data
        • Loading an XML Document
      • Unloading Data
        • Unloading a Text File
        • Unloading to an XML Document
      • Using Text Data Load Repository
    • Generating DDL
    • Viewing Object Reports
      • Table Reports
      • Security Reports
      • PL/SQL Reports
        • Program Unit Arguments
        • Unit Line Counts
        • Search PL/SQL Source Code
      • Exception Reports
      • All Object Reports
    • Using the Recycle Bin to View and Restore Dropped Objects
      • Managing Objects in the Recycle Bin
      • Emptying the Recycle Bin Without Viewing the Objects
    • Reviewing Application Express Views
    • Comparing Schemas
    • Monitoring the Database
      • Sessions
        • Sessions Report
        • Locks Report
        • Waits Report
        • I/O Report
        • SQL Report
        • Open Cursors
      • About System Statistics
      • About Top SQL
      • About Long Operations
    • Viewing Database Details
  • Migrating Applications
    • About Application Migration
    • Preparation Checklist for Migrating Applications
    • How to Migrate Your Applications
    • Step 1: Export Microsoft Access Metadata
    • Step 2: Migrate the Microsoft Access Database to Oracle
    • Step 3: Create an Oracle Application Express Workspace
    • Step 4: Create a Migration Project
      • About the Project Page
    • Step 5: Review Your Retrieved Objects
      • Reviewing Retrieved Tables
      • Reviewing Retrieved Queries
      • Reviewing Retrieved Forms
      • Reviewing Retrieved Reports
      • Reviewing Database, Module, and Pages Information
    • Step 6: Generate the Oracle Application Express Application
    • Managing Your Migration Projects
  • Managing an Oracle Application Express Hosted Service
    • What Is an Oracle Application Express Administrator?
      • About the Manage Services Page
      • About the Manage Workspaces Page
    • Logging in to Oracle Application Express Administration Services
    • Managing Service
      • Creating a Site-Specific Tasks List
        • Adding a New Task
        • Editing an Existing Task
        • Deleting a Task
      • Managing Log Entries
        • Deleting SQL Workshop Logs
        • Deleting Page View Activity Log Entries
        • Deleting Developer Activity Log Entries
        • Deleting Click Counting Log Entries
        • Deleting Mail Log Entries
        • Deleting the Login Access Log
      • Managing Session State
        • Purging Sessions by Age
        • Viewing Session Details Before Purging
        • Viewing Session Statistics Before Purging
      • Managing Mail
        • Viewing the Mail Queue
        • Viewing the Mail Log
      • Viewing Installed Translations
    • Managing Environment Settings
      • Disabling PL/SQL Program Unit Editing for an Instance
      • Disabling the Creation of Demonstration Applications in a New Workspace
      • Configuring SQL Workshop
      • Enabling Database Monitoring
      • Configuring Security Settings
        • Turning Off Cookies Used to Populate the Login Form for Application Express
        • Excluding Domains from Regions of Type URL and Web Services
        • Enabling Login Controls for All Workspaces
        • About Password Policies
        • Configuring Password Policies
        • Disabling Access to Oracle Application Express Administration Services
        • Disabling Access to Oracle Application Express Internal Applications
        • Restricting User Access by IP Address
      • Configuring Email Settings
      • Configuring Wallet Information
      • Configuring Report Printing
        • Setting Up the Printing of Reports
      • Configuring Workspace Size Options for Requests
      • Managing Login and System Messages
        • Managing a Login Message
        • Managing a System Message
    • Managing Schemas
      • Determining the Application Express Engine Schema
      • Understanding Oracle Default Schema Restrictions
        • Granting the Privilege to Assign Oracle Default Schemas
        • Revoking the Privilege to Assign Oracle Default Schemas
        • Working with Restricted Schemas
        • Determining the Privilege Status
    • Creating Workspaces
      • About Workspace Provisioning
      • Specifying a Provisioning Mode
      • Creating a Workspace Manually
      • Managing Workspace to Schema Assignments
        • Viewing the Existing Schema and Workspace Assignment
        • Editing an Existing Schema and Workspace Assignment
        • Associating Additional Schemas to a Workspace
        • Creating a New Schema
    • Managing Workspace Requests
      • Viewing a Pending Workspace Request on the Notifications List
      • Viewing Requests from the Workspace Requests Page
      • Approving or Declining a Pending Workspace Request
        • More About the Approval Process
        • When an Error Occurs
      • Changing the Status of an Existing Workspace Request
      • Deleting a Workspace Request
    • Managing Change Requests
      • Viewing a Pending Change Request from the Notifications List
      • Viewing a Change Request from the Workspace Utilization Report
      • Viewing Requests from the Change Requests Page
      • Approving or Declining a Pending Change Request
    • Managing Users in an Oracle Application Express Instance
      • Creating New User Accounts
      • Editing an Existing User Account
      • Deleting User Accounts
    • Managing Existing Workspaces
      • Viewing Existing Workspaces
      • Viewing Workspace Details
        • About the Workspace Details Page
      • Viewing Workspace Database Privileges
      • About Deleting Inactive Workspaces
        • Identifying Inactive Workspaces
        • Removing the Resources Associated with Inactive Workspaces
        • Deleting Inactive Workspaces
      • Removing a Workspace
      • Locking a Workspace
      • Exporting and Importing a Workspace
        • Exporting a Workspace
        • Importing a Workspace
    • Managing Applications
      • Viewing Application Attributes
      • Changing Application Build Status Set During Deployment
      • Viewing the Parse As Schemas Report
    • Monitoring Activity Across a Development Instance
  • Available Conditions
  • Privileges Granted to PUBLIC
    • Packages
    • Procedures
    • Functions
    • Tables
    • Views
  • Index