Go to main content
1/224
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Changes in This Release
Changes in Oracle Application Express Release 5.0
1
Quick Start
1.1
Understanding Oracle Application Express
1.1.1
What is Oracle Application Express?
1.1.2
How Oracle Application Express Works
1.1.3
About the Differences Between Runtime and Full Development Environments
1.2
Signing In To Oracle Application Express
1.2.1
Browser Requirements
1.2.2
About Application Express User Roles
1.2.3
Overview of Configuring Oracle Application Express
1.2.4
Signing In and Out of a Workspace as a Developer
1.3
Understanding the Workspace Home Page
1.3.1
Workspace Home Page
1.3.2
Top Applications and Top Users Dashboards
1.3.3
News and Messages
1.3.4
Developer Navigation Tools
1.3.5
Available Updates Region
1.3.6
Accessibility Mode Region
1.4
Editing Your Account Profile
1.4.1
Editing Your Account Profile and Preferences
1.4.2
Changing Your Password
1.5
Editing User Preferences
1.6
Using Oracle Application Express Documentation
1.6.1
Accessing Oracle Help Center
1.6.2
Searching the Oracle Help Center
1.6.3
Downloading Online Documents
1.6.4
Searching a Downloaded Documentation Library
1.6.5
Viewing Field-Level Help
2
Application Builder Concepts
2.1
Understanding Oracle Application Express Applications
2.1.1
What is an Oracle Application Express Application?
2.1.2
What is the Difference Between a Database and Websheet Application?
2.1.3
About Running the Create Application Wizard
2.2
Understanding Application Pages
2.2.1
What Is an Application Page?
2.2.2
Understanding the Difference Between Page Designer and Component View
2.2.3
Viewing a Page in Page Designer
2.2.4
Viewing a Page in Component View
2.2.5
Switching from Page Designer to Component View
2.2.6
Switching from Component View to Page Designer
2.3
Managing User Interface Design
2.3.1
About Determining Your Application User Interface
2.3.2
About Mobile Application Design
2.3.3
Understanding the Difference Between Mobile Design and Responsive Design
2.4
Running an Application or Page
2.4.1
Run Application and Run Page Buttons
2.4.2
How Your Browser Impacts the Way Applications Run
2.4.3
Running an Application from the Application Builder Home Page
2.4.4
Running an Application from the Application Home Page
2.4.5
Running a Page on the Application Home Page
2.4.6
Running a Page in Page Designer
2.4.7
Running a Page in Component View
2.5
How Does Page Processing and Page Rendering Work?
2.5.1
How the Application Express Engine Renders and Processes Pages
2.5.2
Understanding Conditional Rendering and Processing
2.5.3
About Verifying User Identity
2.5.4
About Controlling Access to Controls and Components
2.6
Understanding Session State Management
2.6.1
What is Session State?
2.6.2
What Is a Session?
2.6.3
About Session IDs
2.6.4
Viewing Session State
2.7
Understanding URL Syntax
2.7.1
About the Application Page URL
2.7.2
About Using f?p Syntax to Link Pages
2.7.3
Application Alias
2.7.4
Page Alias
2.7.5
Calling a Page Using an Application and Page Alias
2.7.6
Calling a Page from a Button URL
2.8
About Enabling Support for Bookmarks
2.9
Managing Session State Values
2.9.1
About Referencing Session State
2.9.2
Setting Session State
2.9.3
Clearing Session State
2.9.4
Referencing Session State Using Bind Variable Syntax
2.10
Understanding Substitution Strings
2.10.1
About Using Substitution Strings
2.10.2
Controlling Output Escaping in Substitution Strings
2.10.3
About Determining Substitution String Usage within Templates
2.10.4
Using Built-in Substitution Strings
3
Utilizing Packaged Applications
3.1
About Packaged Applications
3.2
Managing Packaged Applications in a Full Development Environment
3.2.1
Viewing the Packaged App Gallery
3.2.2
Viewing the Packaged App Dashboard
3.2.3
Installing a Packaged Application
3.2.4
Running an Installed Packaged Application
3.2.5
Removing an Installed Packaged Application
3.2.6
Changing Authentication for an Installed Packaged Application
3.2.7
Unlocking an Installed Productivity Application
3.2.8
Updating a Packaged Application
3.3
Understanding Sample Database Application
3.3.1
Installing and Running Sample Database Application
3.3.2
Understanding Sample Database Application
3.3.3
Modifying Sample Database Application
3.4
Understanding AnyCo IT Department Websheet
3.4.1
Installing and Running AnyCo IT Department
3.4.2
About Websheet Navigation
3.4.3
Understanding AnyCo IT Department
3.4.4
Modifying Websheet Content
3.5
Using a Packaged Apps Only Workspace
3.5.1
What Is a Packaged Apps Only Workspace?
3.5.2
Requesting a Packaged Apps Only Workspace
3.5.3
Signing In To a Packaged Apps Only Workspace
3.5.4
Using the Packaged App Gallery
3.5.5
Utilizing Packaged App Administration
4
Understanding Application Builder
4.1
Accessing Application Builder
4.2
Using the Application Builder Home Page
4.2.1
Application Builder Home Page Navigation Bar
4.2.2
Reset and Create Buttons
4.2.3
Application Builder Home Recent List
4.2.4
Migrations Link
4.3
Accessing Application Home Page
4.4
Using Application Home Page
4.4.1
Edit Application Properties Button
4.4.2
Application Home Page Icons
4.4.3
Create Page Button
4.4.4
Application Home Page Navigation Bar
4.4.5
About Customizing the Application Home Page
4.4.6
Application Home Page Tasks List
4.4.7
Recently Edited Pages
5
Managing the Application Life Cycle with Team Development
5.1
Accessing Team Development
5.2
Team Development Home Page
5.3
About Utilizing the Tags Summary
5.4
Tracking Features
5.4.1
Viewing the Features Report
5.4.2
Creating a Feature
5.4.3
About Creating Parent Features
5.4.4
Updating a Feature
5.4.5
How to Attach Files to a Feature
5.4.6
Viewing Other Feature Reports
5.5
Tracking Milestones
5.5.1
Viewing the Milestones Report
5.5.2
Creating a Milestone
5.5.3
Updating a Milestone
5.5.4
Viewing Other Milestone Reports
5.6
Tracking To Dos
5.6.1
Viewing To Dos
5.6.2
Creating a To Do
5.6.3
Updating a To Do
5.6.4
How to Attach Files to a To Do
5.6.5
Viewing Other To Do Reports
5.7
Managing Bugs
5.7.1
Viewing Bugs
5.7.2
Creating a Bug
5.7.3
Editing a Bug
5.7.4
How to Attach Files to a Bug
5.7.5
Viewing Other Bug Reports
5.8
Managing Feedback
5.8.1
Viewing Feedback
5.8.2
Adding a Feedback Page to an Application
5.8.3
Submitting Feedback
5.8.4
Reviewing Feedback
5.8.5
Viewing Other Feedback Reports
5.9
Managing Team Development Utilities
5.9.1
Accessing Team Development Utilities
5.9.2
Configuring Team Development Settings
5.9.3
Viewing a Release Summary
5.9.4
Managing Feature Utilities
5.9.5
Editing Focus Areas
5.9.6
Viewing File Attachments
5.9.7
Purging Data
5.9.8
Managing News Entries
5.9.9
Managing Links
6
Creating Websheet Applications
6.1
About Websheet Applications
6.2
Creating a Websheet Application
6.2.1
Creating a Websheet from Application Builder
6.2.2
Creating a Websheet Application from a Running Websheet
6.3
Copying an Existing Websheet Page
6.4
Running a Websheet
6.4.1
Running a Websheet from the Application Builder Home Page
6.4.2
Running a Websheet from the Application Home Page
6.4.3
Determining a Websheet URL
6.5
Editing Page Details
6.6
Deleting a Websheet Application
6.7
Viewing the Websheet Dashboard
6.8
Monitoring Websheet Activity
6.9
Understanding Websheet Properties
6.9.1
Editing Websheet Properties
6.9.2
Websheet Properties
6.10
Controlling Websheet Access
6.10.1
How Websheet Access Works
6.10.2
Specifying the Access Control List Type
6.10.3
Creating Access Control List Entries
7
Creating Database Applications
7.1
Using the Create Application Wizard
7.1.1
About the Create Application Wizard
7.1.2
Available Page Types When Running the Create Application Wizard
7.2
Creating a Database Application
7.2.1
Creating a Database Application Based on a Table, Query, or Drill-Down Query
7.2.2
Creating a Desktop Database Application from a Spreadsheet
7.2.3
Copying a Database Application
7.3
Creating Mobile Applications
7.3.1
About jQuery Mobile Support
7.3.2
Creating a Mobile Application
7.4
Deleting an Application
7.4.1
Deleting an Application from the Application Home Page
7.4.2
Deleting an Application from the Edit Application Definition Page
7.5
Managing Application Attributes
7.5.1
Editing the Application Attributes
7.5.2
Configuring Security Attributes
7.5.3
Configuring Globalization Attributes
7.5.4
Managing the Application User Interface
7.6
Managing Pages in a Database Application
7.6.1
About Adding Pages to a Database Application
7.6.2
Available Pages Types When Running the Create Page Wizard
7.6.3
Creating a Page from the Application Home Page
7.6.4
Creating Dialog Pages
7.6.5
About Managing Pages in Page Designer
7.6.6
About Managing Pages in Component View
7.6.7
About Copying Database Application Pages
7.6.8
About Copying Pages Between User Interfaces
7.6.9
About Deleting Database Application Pages
7.7
Using the Find Icon
7.7.1
About the Find Icon
7.7.2
Using the Find Icon
7.7.3
Searching for Items
7.7.4
Searching for Pages
7.7.5
Searching for Queries
7.7.6
Searching for Tables
7.7.7
Using the PL/SQL Finder
7.7.8
Searching for Images
7.8
Creating Page Groups
7.8.1
Viewing Page Groups
7.8.2
Creating a Page Group
7.8.3
Editing a Page Group Definition
7.8.4
Assigning a Page to a Page Group
7.8.5
Viewing Pages by Page Group
7.8.6
Deleting a Page Group
7.9
Locking and Unlocking a Page
7.9.1
Determining If a Page Is Locked
7.9.2
Locking a Page
7.9.3
Unlocking a Page
7.10
Adding Developer Comments
7.10.1
Developer Comment, Bug, or To Do Button
7.10.2
Adding Developer Comments to an Application
7.10.3
Viewing and Editing Developer Comments
7.10.4
Deleting Developer Comments
7.10.5
Accessing the Developer Comments from Shared Components
7.10.6
Viewing the Developer Comments Calendar
7.11
Adding Database Application Comments
7.12
Managing Application Groups
7.12.1
Viewing Database Application Groups
7.12.2
Creating a Database Application Group
7.12.3
Assigning a Database Application to an Application Group
7.12.4
Removing a Database Application from an Application Group
7.12.5
Deleting an Database Application Group
7.13
Accessing Application Utilities
7.13.1
Using Application Builder Utilities
7.13.2
Accessing Page Specific Utilities
7.13.3
Utilizing Cross Page Utilities
7.13.4
Accessing Cross Application Reports
7.13.5
Using Interactive Report Utilities
8
Managing Pages in Page Designer
8.1
About the Page Designer Window
8.2
Understanding Common Page Designer UI Elements
8.2.1
Page Designer Toolbar
8.2.2
Tree Pane
8.2.3
Central Pane
8.2.4
Grid Layout
8.2.5
Gallery
8.2.6
Messages
8.2.7
Page Search
8.2.8
Help
8.2.9
Property Editor
8.2.10
Code Editor
8.3
Using Page Designer
8.3.1
Viewing a Page in Page Designer
8.3.2
Accessing the Property Editor
8.3.3
Adding a Region, Item, or Button by Dragging and Dropping
8.3.4
Adding a Region, Item, or Button Using Gallery Context Menus
8.3.5
Adding a Region, Item, or Button from the Rendering Tree
8.3.6
Creating Pre-Rendering Branches, Computations, and Processes
8.3.7
Creating Page Submission Branches, Validations, Computations, and Processes
8.3.8
Searching for Pages
8.4
Editing Page Attributes in Page Designer
8.4.1
Viewing Page Attributes in the Property Editor
8.4.2
Property Editor - Page
8.4.3
Incorporating JavaScript Using Page Designer
8.4.4
Configuring Rejoin Sessions in Page Designer
8.4.5
Configuring Dialogs Attributes in Page Designer
8.5
Running a Page in Page Designer
8.6
Runtime Developer Toolbar
8.7
Copying a Database Application Page in Page Designer
8.8
Deleting Pages in Page Designer
8.8.1
Deleting a Page in Page Designer
8.8.2
Deleting Multiple Pages
8.8.3
Deleting a Range of Pages
9
Managing Pages in Component View
9.1
About the Component View Window
9.2
Understanding Component View Common UI Elements
9.2.1
Component View Toolbar
9.2.2
Navigation Bar
9.3
Using Component View
9.3.1
Viewing a Page in Component View
9.3.2
Editing a Page in Component View
9.3.3
Understanding Page Rendering
9.3.4
Understanding Page Processing
9.3.5
Understanding Shared Components
9.3.6
Creating a Page Control Component View
9.4
Editing Page Attributes in Component View
9.4.1
Viewing Page Attributes in Component View
9.4.2
Page Attributes in Component View
9.4.3
Incorporating JavaScript Using Component View
9.4.4
Configuring Rejoin Sessions in Component View
9.4.5
Configuring Dialog Attributes in Component View
9.5
Running an Application or Page in Component View
9.6
Runtime Developer Toolbar
9.7
Copying a Database Application Page in Component View
9.8
Deleting Pages in Component View
9.8.1
Deleting a Page in Component View
9.8.2
Deleting a Page While Editing Page Attributes
9.8.3
Deleting Multiple Pages
9.8.4
Deleting a Range of Pages
10
Developing Reports
10.1
Understanding the Difference Between Interactive and Classic Reports
10.1.1
Interactive Reports
10.1.2
Classic Reports
10.2
Creating Reports Using a Wizard
10.2.1
Create Application Wizard Report Options
10.2.2
Create Page Wizard Report Options
10.2.3
Create Region Wizard Report Options
10.2.4
Creating a Report Using the Create Application Wizard
10.2.5
Creating a Report Using the Create Page Wizard
10.2.6
Creating a Report in Page Designer Using a Wizard
10.3
Creating a Report by Dragging and Dropping from the Gallery
10.4
Editing Interactive Reports in Page Designer
10.4.1
Editing Region Attributes in Page Designer
10.4.2
Editing Column Attributes in Page Designer
10.4.3
Editing Interactive Report Attributes in Page Designer
10.4.4
Controlling Interactive Report Pagination in Page Designer
10.4.5
Customizing the Interactive Report Search Bar
10.4.6
Customizing the Actions Menu in Page Designer
10.4.7
Managing Link Columns in Page Designer
10.4.8
Creating a Column Link in an Interactive Report
10.4.9
Displaying Interactive Reports Conditionally
10.4.10
Defining a Column as a List of Values in an Interactive Report
10.4.11
Enabling Icon View in Page Designer
10.4.12
Formatting Columns in an Interactive Report
10.4.13
Enabling Detail View in Page Designer
10.4.14
Configuring Advanced Attributes for Interactive Reports
10.4.15
Linking to Interactive Reports
10.5
Editing Interactive Reports in Component View
10.5.1
Editing Interactive Report Attributes in Component View
10.5.2
Editing Column Attributes in Component View
10.5.3
Creating Column Groups
10.5.4
Controlling Interactive Report Pagination in Component View
10.5.5
Managing the Search Bar and Actions Menu in Component View
10.5.6
Managing Link Columns in Component View
10.5.7
Creating a Column Link in an Interactive Report
10.5.8
Displaying Interactive Reports Conditionally
10.5.9
Defining a Column as a List of Values in an Interactive Report
10.5.10
Formatting Columns in an Interactive Report
10.5.11
Enabling Icon View in Component View
10.5.12
Enabling Detail View in Component View
10.5.13
Configuring Interactive Report Advanced Attributes
10.5.14
Linking to Interactive Reports
10.5.15
Linking to Shared Interactive Reports
10.5.16
Editing Saved Default Interactive Reports in Component View
10.5.17
Viewing Saved Interactive Report Activity
10.6
Customizing Interactive Reports as an End User
10.6.1
About the Search Bar
10.6.2
About the Actions Menu
10.6.3
Using Interactive Report Filters
10.6.4
Saving Interactive Reports
10.7
Editing Classic Reports in Page Designer
10.7.1
Editing Classic Report Attributes in Page Designer
10.7.2
Altering Classic Report Layout in Page Designer
10.7.3
Controlling Classic Report Pagination in Page Designer
10.7.4
Enabling Column Sorting in a Classic Report in Page Designer
10.7.5
Adding a Download Link to a Classic Report in Page Designer
10.7.6
Enabling Classic Report CSV Output Option in Page Designer
10.7.7
Adding Support for XML File or a CSV File Export in Page Designer
10.7.8
Creating a Column Link in a Classic Report in Page Designer
10.7.9
Defining an Updatable Column in a Classic Report in Page Designer
10.7.10
Defining a Column as a List of Values in a Classic Report in Page Designer
10.7.11
Controlling When Classic Report Columns Display in Page Designer
10.7.12
Controlling Classic Report Column Breaks in Page Designer
10.8
Editing Classic Reports in Component View
10.8.1
Editing Classic Report Attributes in Component View
10.8.2
Altering Classic Report Layout in Component View
10.8.3
Controlling Classic Report Pagination in Component View
10.8.4
Enabling Column Sorting in a Classic Report in Component View
10.8.5
Adding a Download Link to a Classic Report in Component View
10.8.6
Enabling Classic Report CSV Output in Component View
10.8.7
Adding Support for XML File or a CSV File Export
10.8.8
Creating a Column Link in a Classic Report in Component View
10.8.9
Defining an Updatable Column in Component View
10.8.10
Defining a Column as a List of Values in a Classic Report in Component View
10.8.11
Controlling When Classic Report Columns Display in Component View
10.8.12
Controlling Classic Report Column Breaks in Component View
10.8.13
Synchronizing Classic Report Column Order with Region Source
10.9
Printing Report Regions
10.9.1
About Printing Reports to PDF
10.9.2
About Report Printing Configuration Options
10.9.3
About Classic Report Printing Methods
10.9.4
Configuring Classic Report Region Print Attributes
10.9.5
Configuring Interactive Report Region Print Attributes
10.9.6
About Report Queries
10.9.7
About Report Laoyouts
10.10
Understanding BLOB Support in Forms and Reports
10.10.1
About BLOB Support in Reports
10.10.2
About Providing a Download Link
10.10.3
About Displaying the BLOB
10.10.4
About Working With BLOBs Procedurally
11
Developing Forms
11.1
Using a Wizard to Create a Form
11.1.1
Create Page Wizard Form Options
11.1.2
Create Region Wizard Form Options
11.1.3
Creating a Form Using the Create Page Wizard
11.1.4
Creating a Form Using the Create Application Wizard
11.1.5
Creating a Form in Page Designer
11.2
Managing Tabular Forms
11.2.1
About Creating Tabular Forms
11.2.2
About Running a Tabular Form
11.2.3
How Tabular Forms Work
11.2.4
Creating a Tabular Form Using the Create Application Wizard
11.2.5
Creating a Tabular Form Using the Create Page Wizard
11.2.6
Synchronizing Tabular Form Column Order with Region Source
11.3
Managing Master Detail Forms
11.3.1
About Master Detail Forms
11.3.2
Creating a Master Detail Form Using the Create Application Wizard
11.3.3
Creating a Master Detail Form Using the Create Page Wizard
11.4
Creating a Form Manually in Component View
11.4.1
About Creating Forms Manually in Component View
11.4.2
Processing a Form
11.4.3
Populating Forms in Component View
11.5
Validating User Input in Forms
11.5.1
About Creating Validations and Error Messages
11.5.2
Associating a Validation with a Specific Item in Page Designer
11.5.3
Associating a Validation with a Specific Item in Component View
11.5.4
About the Error Message Display Location
11.6
Understanding BLOB Support in Forms
11.6.1
About BLOB Support in Forms
11.6.2
About Uploading and Downloading Files into a BLOB
11.6.3
About Displaying the BLOB
11.6.4
About Removing the Image Reference
12
Managing Database Application Components
12.1
Creating Calendars
12.1.1
About Supported Calendars
12.1.2
Sample Calendar
12.1.3
Adding a Calendar to a New Page
12.1.4
Managing Calendar Attributes in Page Designer
12.1.5
Managing Calendars in Component View
12.1.6
About the Date Column Format Mask
12.1.7
Enabling the Dragging and Dropping of Data In an Existing Calendar
12.1.8
About Supported Calendar Substitution Strings in Legacy Calendars
12.2
Creating Maps
12.2.1
About Map Chart Support
12.2.2
About Creating SQL Queries for Maps
12.2.3
Adding Map Charts to a New Page
12.2.4
Managing Map Charts in Page Designer
12.2.5
Managing Map Charts in Component View
12.3
Creating Charts
12.3.1
About Chart Types
12.3.2
Creating SQL Queries for Charts
12.3.3
Adding a Chart to a New Page
12.3.4
Managing Charts in Page Designer
12.3.5
Managing Charts in Component View
12.3.6
Understanding SVG Chart Support
12.3.7
Understanding HTML Chart Support
12.3.8
About Saving Flash Charts
12.3.9
Using Custom XML with Flash and HTML5 Charts
12.4
Creating Help for Your Application
12.4.1
Creating Help in Page Designer
12.4.2
Creating Help in Component View
12.4.3
Editing Multiple Item Help Topics Simultaneously
12.4.4
Creating a Help Navigation Bar Entry
13
Using Themes and Theme Styles
13.1
Using Themes
13.1.1
About Themes
13.1.2
About Responsive Design
13.1.3
About Grid-based Themes
13.1.4
Using Theme Styles
13.1.5
Understanding Template Options
13.1.6
Accessing the Themes Page
13.1.7
Editing Themes
13.2
Managing Themes and Subscriptions
13.2.1
Understanding Theme Subscriptions
13.2.2
Creating a Theme
13.2.3
Switching Themes
13.2.4
Changing a Theme Identification Number
13.2.5
Copying a Theme
13.2.6
Deleting a Theme
13.2.7
Creating a Master Theme Application
13.2.8
Managing Workspace Themes
13.2.9
Managing Instance Themes
13.2.10
About Exporting and Importing Themes
13.2.11
Viewing Theme Reports
13.3
Creating Custom Themes
13.3.1
About Cascading Style Sheets
13.3.2
About Calling the JavaScript File from the Page Template
13.3.3
About Using Escaping Syntax in Substitution Strings
13.3.4
Selecting a Default Page Template
13.3.5
Creating a New Template
13.3.6
Using Template Options
13.3.7
Viewing Template Reports
13.3.8
Managing Templates
13.3.9
Breadcrumb Templates
13.3.10
Button Templates
13.3.11
Legacy Calendar Templates
13.3.12
Label Templates
13.3.13
List Templates
13.3.14
Page Templates
13.3.15
Popup LOV Templates
13.3.16
Region Templates
13.3.17
Report Templates
13.4
Using Custom Cascading Style Sheets
13.4.1
About Uploading Cascading Style Sheets
13.4.2
Referencing an Uploaded Cascading Style Sheet in the Page Template
14
Controlling Page Layout
14.1
About Page Layout in Oracle Application Express
14.2
Optimizing a Page for Printing
14.2.1
Selecting a Printer Friendly Template for an Application
14.2.2
Using f?p Syntax to Toggle to Printer Friendly Mode
14.3
Creating a Global Page to Display Components on Every Page
14.3.1
Creating a Global Page
14.3.2
Navigating to the Global Page
14.4
About Regions
14.5
Managing Regions in Page Designer
14.5.1
Creating a Region in Page Designer
14.5.2
Managing Regions in Page Designer
14.5.3
Copying a Region in Page Designer
14.5.4
Deleting Regions in Page Designer
14.6
Managing Regions in Component View
14.6.1
About Region Types When Running the Create Region Wizard
14.6.2
Creating a Region in Component View
14.6.3
Managing Regions in Component View
14.6.4
Creating a Region Display Selector
14.6.5
Copying a Region in Component View
14.6.6
Deleting Regions in Component View
14.7
About Incorporating Content from Other Web Sites
14.8
About Managing Images
14.9
Rendering HTML Using Custom PL/SQL
15
Managing Database Application Controls
15.1
Understanding Page-Level Items
15.1.1
About the Differences Between Page Items and Application Items
15.1.2
About Item Naming Conventions
15.1.3
Referencing Item Values
15.1.4
About Referencing Items Using JavaScript
15.1.5
Working with Multiple Select List Item
15.2
Managing Page-Level Items in Page Designer
15.2.1
Viewing Page-Level Items in Page Designer
15.2.2
Creating Page-Level Items
15.2.3
Editing Page-Level Items in Page Designer
15.3
Managing Page-Level Items in Component View
15.3.1
Viewing Page-Level Items in the Component View
15.3.2
Creating Page-Level Items in Component View
15.3.3
Editing Page-Level Items in Component View
15.4
Managing Dynamic Actions
15.4.1
About Dynamic Actions
15.4.2
Viewing Plug-in Examples
15.4.3
About Dynamic Action Events
15.4.4
Managing Dynamic Actions in Page Designer
15.4.5
Managing Dynamic Actions in Component View
15.4.6
About Calling JavaScript Using a Dynamic Action
15.4.7
Debugging Dynamic Actions
15.5
Creating Buttons
15.5.1
What Actions Can a Button Perform?
15.5.2
Managing Buttons in Page Designer
15.5.3
Managing Buttons in Component View
15.5.4
About Calling JavaScript from a Button
15.5.5
About the Relationship Between Button Names and REQUEST
15.5.6
About Branching with Buttons
15.6
Creating Trees
15.6.1
About Trees
15.6.2
About Support for Legacy jsTrees
15.6.3
Creating a Tree on New Page
15.6.4
Managing Trees in Page Designer
15.6.5
Managing Trees in Component View
15.7
About Incorporating JavaScript into an Application
16
Adding Navigation
16.1
About Creating Lists as Navigation
16.2
Creating Tabs
16.2.1
About Tabs
16.2.2
About the Tabs Page
16.2.3
Checking for Tab Template Support
16.2.4
Creating a Tab
16.2.5
Editing Tabs
16.2.6
Accessing Tab Reports
16.3
Creating Breadcrumbs
16.3.1
What Are Breadcrumbs?
16.3.2
Creating a Breadcrumb While Creating a Page
16.3.3
Creating a Breadcrumb Manually
16.3.4
Editing Breadcrumbs
16.3.5
Reparenting Breadcrumb Entries
16.3.6
Deleting Unused Breadcrumb Entries
16.3.7
Accessing Breadcrumb Reports
16.4
Creating a Navigation Bar Entry
16.4.1
About Navigation Bars
16.4.2
Creating a Navigation Bar Entry
16.4.3
Copying a Navigation Bar Entry
16.4.4
Editing a Navigation Bar Entry
16.4.5
Editing Multiple Navigation Bar Entries Simultaneously
16.4.6
Accessing Navigation Bar Entry Reports
16.5
Controlling Navigation Using Branches
16.5.1
Creating a Branch in Page Designer
16.5.2
Creating a Branch in Component View
16.5.3
About Branching Conditionally
17
Managing Computations, Validations, and Processes
17.1
Understanding Page Computations
17.1.1
About Page Computations
17.1.2
Managing Page Computations in Page Designer
17.1.3
Managing Page Computations in Component View
17.1.4
Computation Points and Computation Syntax Example
17.2
Understanding Validations
17.2.1
About Validations
17.2.2
Managing Validations in Page Designer
17.2.3
Managing Validations in Component View
17.2.4
About Determining When Validations Execute
17.2.5
About Defining How Validation Error Messages Display
17.2.6
Processing Validations Conditionally
17.2.7
About Altering the Go to Error Link
17.2.8
What Happens When a Validation Fails?
17.3
Understanding Page Processes
17.3.1
About Page Processes
17.3.2
Managing Page Processes in Page Designer
17.3.3
Managing Page Processes in Component View
17.4
About Branches
17.5
Understanding Application Processes
17.5.1
About On Demand Application Processes
17.5.2
About Application Processes that Execute On New Instance
17.5.3
About Running an On Demand Process from a Page Request
17.5.4
Application Process Example
17.5.5
Creating an Application Process
17.5.6
Editing Application Process Attributes
17.5.7
Creating Application Process Error Messages
17.5.8
Viewing the Application Processes History Report
17.6
Understanding Application Computations
17.6.1
About Application Computations
17.6.2
About Application Computations that Execute On New Instance
17.6.3
Creating an Application Computation
17.6.4
Accessing the Application Computation History Report
17.7
Using the Attribute Dictionary
17.7.1
About the Attribute Dictionary
17.7.2
Accessing the Manage Attribute Dictionary
18
Managing Shared Components
18.1
Working with Shared Components
18.1.1
About the Advantages of Using Shared Components
18.1.2
Accessing the Shared Components Page
18.1.3
About the Shared Components Icon
18.1.4
Shared Components Page
18.2
Managing Component Settings
18.2.1
Editing Component Settings
18.2.2
Viewing the Component Settings History Report
18.3
Managing Static Application Files
18.3.1
Specifying the Location of Static Application Files
18.3.2
Uploading Static Application Files
18.3.3
Viewing the Static Application File Report
18.3.4
About Referencing Static Application Files
18.3.5
Downloading Static Application Files
18.3.6
Deleting Static Application Files
18.4
Managing Static Workspace Files
18.4.1
Uploading Static Workspace Files
18.4.2
Viewing Static Workspace File Report
18.4.3
About Referencing Static Workspace Files
18.4.4
Downloading Static Workspace Files
18.4.5
Deleting Static Workspace Files
18.5
Managing Application-Level Items
18.5.1
Creating an Application-Level Item
18.5.2
Viewing Application Item Usage
18.5.3
Editing Application-Level Item Attributes
18.5.4
About Creating an Application-Level Item that Functions as a Global Variable
18.6
Creating Lists of Values at the Application Level
18.6.1
What is a List of Values?
18.6.2
Creating a Named LOV at the Application Level
18.6.3
About Static LOVs
18.6.4
Editing an Existing LOV
18.6.5
About Referencing Session State Within an LOV
18.6.6
Accessing LOV Reports
18.7
Creating Lists
18.7.1
About Creating Lists
18.7.2
About Navigation Menus
18.7.3
Creating Static Lists
18.7.4
Creating Dynamic Lists
18.7.5
Copying a List
18.7.6
Adding a List to a Page
18.7.7
Editing List Attributes
18.7.8
Accessing List Reports
18.8
Using Shortcuts
18.8.1
What is a Shortcut?
18.8.2
Understanding Shortcut Types
18.8.3
Defining and Referencing Shortcuts
18.8.4
Editing Existing Shortcuts
18.8.5
Accessing Shortcut Reports
18.9
Managing Report Output
18.9.1
Printing a Report Region by Defining a Report Query
18.9.2
Formatting a Report Region or Report Query Using Report Layouts
19
Extending Application Capabilities
19.1
Sending Email from an Application
19.1.1
About Configuring Email
19.1.2
About Email Provisioning
19.1.3
About the Mail Queue
19.1.4
About the APEX_MAIL Package
19.2
Implementing Plug-ins
19.2.1
About Plug-ins
19.2.2
Viewing Plug-in Examples
19.2.3
Accessing the Plug-ins Page
19.2.4
Creating a Plug-in
19.2.5
Editing a Plug-in
19.2.6
Adding Custom Attributes to a Plug-in
19.2.7
Uploading Files Associated with a Plug-in
19.2.8
Adding Events to a Plug-in
19.2.9
Deleting a Plug-in
19.2.10
Viewing the Plug-in Repository
19.2.11
Importing a Plug-in from the Plug-in Page
19.2.12
Exporting a Plug-in from the Plug-in Page
19.2.13
Resetting the Plug-in Interactive Report
19.2.14
Viewing Plug-in Utilization Page
19.2.15
Viewing Plug-in History
19.3
Understanding jQuery and jQuery UI Support
19.3.1
About Updated JavaScript Libraries for jQuery and jQueryUI
19.3.2
About Available jQuery UI Features
19.3.3
Referencing the jQuery Library in Your JavaScript Code
19.4
Manually Refreshing Oracle Application Express Components
20
Managing Application Security
20.1
Understanding Administrator Security Best Practices
20.1.1
About Oracle Application Express Administrator Roles
20.1.2
About Configuring Oracle REST Data Services with Oracle Application Express
20.1.3
About Configuring Oracle HTTP Server with mod_plsql with Oracle Application Express
20.1.4
About Security Considerations When Using the Embedded PL/SQL Gateway
20.1.5
Managing Instance Security
20.1.6
Configuring Instance Settings
20.1.7
About Configuring Workspace Purge Settings
20.1.8
Understanding Workspace Management
20.1.9
About Integrating with Oracle BI Publisher
20.1.10
About the Advantages of the Application Express Runtime Environment
20.1.11
Enabling Network Services in Oracle Database 11
g
or Later
20.2
Understanding Developer Security Best Practices
20.2.1
About Items of Type Password
20.2.2
Identifying At Risk Password Items
20.2.3
Understanding Cross-Site Scripting Protection
20.2.4
About Session State and Security
20.2.5
Understanding Session State Protection
20.2.6
About Securing File Uploads
20.3
Controlling Access to Applications, Pages, and Page Components
20.3.1
How the Access Control List Works
20.3.2
Creating an Access Control List
20.3.3
Selecting an Application Mode and Adding Users
20.3.4
About Controlling Access for Pages and Page Components
20.4
Establishing User Identity Through Authentication
20.4.1
Understanding Authentication
20.4.2
Creating an Authentication Scheme
20.4.3
Understanding Preconfigured Authentication Schemes
20.4.4
Managing Existing Authentication Schemes
20.4.5
Viewing the Authentication Scheme Associated with an Application
20.4.6
Changing the Authentication Scheme Associated with an Application
20.4.7
Creating a Login Page
20.4.8
Viewing Authentication Scheme Reports
20.5
Providing Security Through Authorization
20.5.1
How Authorization Schemes Work
20.5.2
Creating and Editing an Authorization Scheme
20.5.3
Attaching an Authorization Scheme to an Application, Page, or Components
20.5.4
Viewing Authorization Reports
21
Managing Application Globalization
21.1
Understanding Application Translation and Globalization Support
21.1.1
About the Translation Process
21.1.2
About Language Identification
21.1.3
About the Rules for Translating Database Applications
21.1.4
How Translated Applications Are Rendered
21.1.5
Making Application Attributes Translatable
21.2
Specifying the Primary Language for an Application
21.2.1
Using Format Masks for Items
21.2.2
About Translating Applications for Multibyte Languages
21.3
Understanding the Translation Process
21.3.1
Step 1: Map the Target Language
21.3.2
Step 2: Seed and Download to a Translation File
21.3.3
Step 3: Translate the XLIFF File
21.3.4
Step 4: Upload and Apply a Translated XLIFF Document
21.3.5
Step 5: Publish the Application
21.3.6
Manually Editing a Translation
21.4
Translating Messages
21.4.1
About Translating Messages
21.4.2
Translating Messages Used in PL/SQL Procedures
21.4.3
Translating Messages Used Internally by Oracle Application Express
21.5
Translating Data That Supports List of Values
21.5.1
Defining a Dynamic Translation
21.6
Understanding Supported Globalization Codes
21.6.1
Oracle Application Express Globalization Codes
22
Debugging an Application
22.1
Running Advisor to Check Application Integrity
22.1.1
About Oracle Application Express Advisor
22.1.2
Running Advisor on an Entire Application
22.1.3
Running Advisor on a Single Page
22.2
Reviewing Session State
22.3
About Monitoring Application and Page Resource Use
22.4
Enabling SQL Tracing and Using TKPROF
22.5
Utilizing Debug Mode
22.5.1
About Debug Mode
22.5.2
Enabling and Disabling Debug Mode for an Application
22.5.3
Running an Application in Debug Mode
22.5.4
Viewing Debug Reports in Development Mode
22.5.5
About Using f?p Syntax to Access Debug Mode
22.5.6
Viewing Debug Reports from a Running Application
22.5.7
Viewing Debug Reports
22.6
Removing Controls and Components to Isolate a Problem
23
Managing Application Performance
23.1
About Best Practices to Improve Performance
23.2
Identifying Performance Issues
23.2.1
About Troubleshooting Slow Running Applications
23.2.2
Diagnosing Performance Issues
23.2.3
About Debugging Problematic SQL Queries
23.2.4
About Addressing Slow Queries
23.3
Utilizing Logs and Reports
23.3.1
How to Manage Log Files
23.3.2
Viewing the Application Dashboard Report
23.3.3
Workspace Activity Reports
23.3.4
Instance Activity Reports
23.4
About Utilizing Database Reporting
23.5
About Database Parameters that Impact Performance
23.6
About Limiting Resources
23.7
About Uploading Static Files to Your Web Server
23.8
Creating Custom Activity Reports Using APEX_ACTIVITY_LOG
23.8.1
Enabling Logging for an Application
23.8.2
APEX_ACTIVITY_LOG
23.8.3
APEX_ACTIVITY_LOG Sample Query
24
Deploying an Application
24.1
About Suggested Environments
24.2
System Development Life Cycle Methodologies to Consider
24.2.1
About Iterative Vs Planned Development
24.2.2
About the Advantages of Creating Prototypes
24.2.3
Waterfall
24.2.4
Spiral
24.2.5
Rapid Application Development
24.3
Understanding the Deployment Process
24.3.1
About Moving an Application to Another Instance
24.3.2
Deployment Options to Consider
24.3.3
About Whether to Copy a Workspace
24.3.4
About Whether to Copy a Database
24.3.5
About the Application ID
24.4
How to Move an Application to Another Instance
24.4.1
About Managing Database Objects
24.5
How to Create a Custom Packaged Application
24.5.1
How Creating a Custom Packaged Application Simplifies Deployment
24.5.2
Creating a Custom Packaged Application
24.5.3
Adding an Access Control List to a Custom Packaged Application
24.5.4
Installing Supporting Objects
24.5.5
Deleting Supporting Objects Scripts, Messages, and Installation Options
24.5.6
Upgrading a Custom Packaged Application
24.5.7
Deinstalling Supporting Objects
24.5.8
Viewing an Install Summary
24.6
Exporting an Application and Application Components
24.6.1
About the Export Process
24.6.2
About The Export Page
24.6.3
Exporting an Application
24.6.4
Exporting Application Components
24.6.5
Exporting a Workspace
24.6.6
Exporting a Page in an Application
24.6.7
Exporting a Websheet
24.6.8
About Exporting Static Files
24.6.9
Exporting Themes
24.6.10
Exporting Plug-ins
24.6.11
Exporting User Interface Defaults
24.6.12
Exporting Team Development Feedback
24.6.13
Exporting Script Files from the Script Repository
24.7
Importing Export Files
24.7.1
Importing an Application, Page or Component Export
24.7.2
About Importing Application Groups
24.7.3
Importing a Websheet
24.7.4
Importing Plug-ins
24.7.5
Importing Themes
24.7.6
Importing User Interface Defaults
24.7.7
Importing Team Development Feedback
24.8
Installing Export Files
24.8.1
About Installing Export Files
24.8.2
Accessing the Export Repository
24.8.3
Installing an Application Export from the Export Repository
24.8.4
Installing Other Files from the Export Repository
24.8.5
Deleting Files from the Export Repository
24.8.6
Installing Export Files from SQL*Plus
24.8.7
Using SQL*Plus to Install Export Files
24.9
About Publishing the Database Application URL
24.10
About Publishing the Websheet Application URL
24.11
Using Build Options to Control Configuration
24.11.1
Creating Build Options
24.11.2
Managing Build Options
24.11.3
Selecting a Build Option
24.11.4
Exporting Build Options or Build Option Status
24.11.5
Viewing the Build Option Utilization Report
25
Managing Application Data
25.1
Creating Applications with Data Loading Capability
25.1.1
About Creating a Data Load Wizard
25.1.2
Creating a Data Load Wizard
25.1.3
Re-creating a Data Load Pages
25.1.4
Editing the Data Load Definition
25.2
About Using Collections
25.3
Implementing Web Services
25.3.1
About Web Services
25.3.2
Creating Web Service References in Oracle Application Express
25.3.3
About Working with SSL Enabled Web Services
25.3.4
Creating Web Service References Based on a WSDL
25.3.5
Creating Web Service References Manually
25.3.6
Creating RESTful Web Service References
25.3.7
Using the Web Service Reference Repository
25.3.8
Creating an Input Form and Report on a Web Service
25.3.9
Creating a Form on a Web Service
25.3.10
How to Invoke a Web Service as a Process
25.3.11
Editing a Web Service Process
25.3.12
Viewing a Web Service Reference History
25.3.13
Exposing a Report Region as a RESTful Web Service
25.4
Accessing Data with Database Links
25.4.1
About Database Links
25.4.2
Creating a Database Link
25.4.3
Viewing an Existing Database Link
25.5
About DML Locking
25.5.1
About DML Locking
25.5.2
APEX_DML_LOCK_WAIT_TIME
25.5.3
FSP_DML_LOCK_ROW
A
About Item Types
A.1
Available Item Types
B
Oracle Application Express Limits
B.1
Component Limits
C
Available Conditions
C.1
About Conditions
C.2
Conditions Available in Application Builder
D
About Granted Privileges
D.1
About Granting Privileges to Database Users
D.2
Understanding Privileges Granted to PUBLIC
D.2.1
Packages
D.2.2
Procedures
D.2.3
Functions
D.2.4
Tables
D.2.5
Views
D.2.6
Sequences
D.2.7
Types
E
Accessibility in Oracle Application Express
E.1
Understanding Screen Reader Mode
E.1.1
Enabling Screen Reader Mode
E.1.2
Using Screen Reader Mode in Your Database Applications
E.1.3
What Does Screen Reader Mode Do?
E.2
Understanding High Contrast Mode
E.2.1
Enabling High Contrast Mode in a Websheet Application
E.2.2
Using High Contrast Mode in Your Database Applications
E.2.3
What Does High Contrast Mode Do?
E.3
Accessing Form Pages Using JAWS
E.3.1
About the Structure of Pages
E.3.2
Accessing Help Text
E.3.3
Dealing with Validation Errors
E.4
Accessing Oracle Application Express Using a Keyboard
E.4.1
Using New Date Pickers
E.4.2
Accessing Interactive Report Regions
E.4.3
Keyboard Shortcuts
Index
Scripting on this page enhances content navigation, but does not change the content in any way.