Go to main content
1/292
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Changes in This Release
Changes in Oracle Application Express Release 18.1
New Features
Deprecated and Desupported Features
Other Changes
1
Quick Start
1.1
About Accessing Your Development Environment
1.2
Understanding Oracle Application Express
1.2.1
What is Oracle Application Express?
1.2.2
How Oracle Application Express Works
1.2.3
About the Differences Between Runtime and Full Development Environments
1.3
Understanding the Workspace Home Page
1.3.1
Workspace Home Page
1.3.2
Top Apps and Top Users Dashboards
1.3.3
News and Messages Region
1.3.4
Developer Navigation Tools
1.3.4.1
Global Search
1.3.4.2
Administration Menu
1.3.4.3
Help Menu
1.3.4.4
Account Menu
1.3.5
Available Updates Region
1.4
Understanding
App Builder
1.4.1
Accessing
App Builder
1.4.2
Understanding the
App Builder
Home Page
1.4.2.1
App Builder
Home Page Icons and Navigation Bar
1.4.2.2
Reset and Create Buttons
1.4.2.3
Recent List, Tasks List, and Migrations Link
1.4.2.4
Workspace Utilities
1.4.2.5
Viewing Cross Application Reports
1.4.3
Accessing the Application Home Page
1.4.4
Understanding the Application Home Page
1.4.4.1
Edit Application Properties Button
1.4.4.2
Application Home Page Icons
1.4.4.3
Create Page Button
1.4.4.4
Application Home Page Navigation Bar
1.4.4.5
Application Home Page Tasks List
1.4.4.6
Recently Edited Pages
1.5
Changing Your Profile or Password
1.6
Editing User Preferences
1.7
Using Oracle Application Express Documentation
1.7.1
Accessing Oracle Help Center
1.7.2
Searching the Oracle Help Center
1.7.3
Downloading the Documentation Library
1.7.4
Viewing Field-Level Help
1.7.4.1
Viewing Field-level Help in Oracle Application Express
1.7.4.2
Viewing Help in Page Designer
2
App 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.2
Running an Application or Page
2.2.1
Run Application and Run Page Buttons
2.2.2
How Your Browser Impacts the Way Applications Run
2.2.3
Running an Application from the App Builder Home Page
2.2.4
Running an Application from the Application Home Page
2.2.5
Running a Page on the Application Home Page
2.3
How Does Page Processing and Page Rendering Work?
2.3.1
How the Application Express Engine Renders and Processes Pages
2.3.2
About Implicit Commit Points
2.3.3
Understanding Conditional Rendering and Processing
2.3.3.1
What is a Condition?
2.3.3.2
Selecting a Condition
2.3.3.3
Condition Example: Current Page in Expression 1
2.3.3.4
Condition Example: Exists
2.3.3.5
Condition Example: PL/SQL Expression
2.3.4
About Verifying User Identity
2.3.5
About Controlling Access to Controls and Components
2.4
About Enabling Support for Bookmarks
2.5
Understanding Session State Management
2.5.1
What is Session State?
2.5.2
About Session IDs
2.5.3
What Is a Session?
2.6
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
Calling a Page Using an Application Alias or Page Alias
2.7.4
Calling a Page from a Button URL
2.8
Managing Session State Values
2.8.1
About Referencing Session State
2.8.2
About Setting Session State
2.8.3
Clearing Session State
2.8.3.1
About Clearing Cache for an Item
2.8.3.2
About Clearing Cache for All Page Items
2.8.3.3
Clearing Cache for an Entire Application
2.8.3.4
About Resetting an Application Completely
2.8.3.5
About Clearing Cache for the Current User Session
2.8.4
Referencing Session State Using Bind Variable Syntax
2.8.4.1
About Using Bind Variable Syntax
2.8.4.2
About Using Bind Variables in Regions Based on a SQL Query or LOV
2.8.4.3
About Using Bind Variables in Regions Based on PL/SQL
2.8.5
About Session Cloning
2.9
Using Substitution Strings
2.9.1
About Using Substitution Strings
2.9.2
Controlling Output Escaping in Substitution Strings
2.9.3
About Determining Substitution String Usage within Templates
2.9.4
Using Built-in Substitution Strings
2.9.4.1
APEX$ROW_NUM
2.9.4.2
APEX$ROW_SELECTOR
2.9.4.3
APEX$ROW_STATUS
2.9.4.4
APP_ID
2.9.4.5
APP_ALIAS
2.9.4.6
APP_AJAX_X01, ... APP_AJAX_X10
2.9.4.7
APP_BUILDER_SESSION
2.9.4.8
APP_DATE_TIME_FORMAT
2.9.4.9
APP_IMAGES
2.9.4.10
APP_NLS_DATE_FORMAT
2.9.4.11
APP_NLS_TIMESTAMP_FORMAT
2.9.4.12
APP_NLS_TIMESTAMP_TZ_FORMAT
2.9.4.13
APP_PAGE_ALIAS
2.9.4.14
APP_PAGE_ID
2.9.4.15
APP_REQUEST_DATA_HASH
2.9.4.16
APP_SESSION
2.9.4.17
APP_SESSION_VISIBLE
2.9.4.18
APP_TITLE
2.9.4.19
APP_UNIQUE_PAGE_ID
2.9.4.20
APP_USER
2.9.4.21
AUTHENTICATED_URL_PREFIX
2.9.4.22
BROWSER_LANGUAGE
2.9.4.23
CURRENT_PARENT_TAB_TEXT
2.9.4.24
DEBUG
2.9.4.25
HOME_LINK
2.9.4.26
IMAGE_PREFIX
2.9.4.27
JET_BASE_DIRECTORY
2.9.4.28
JET_CSS_DIRECTORY
2.9.4.29
JET_JS_DIRECTORY
2.9.4.30
LOGIN_URL
2.9.4.31
LOGOUT_URL
2.9.4.32
APP_TEXT$Message_Name, APP_TEXT$Message_Name$Lang
2.9.4.33
PRINTER_FRIENDLY
2.9.4.34
PROXY_SERVER
2.9.4.35
PUBLIC_URL_PREFIX
2.9.4.36
REQUEST
2.9.4.37
Using REQUEST
2.9.4.37.1
About Scope and Value of REQUEST for Posted Pages
2.9.4.37.2
About the When Button Pressed Attribute
2.9.4.37.3
About Referencing REQUEST Using Declarative Conditions
2.9.4.37.4
About Using REQUEST for Show Processing
2.9.4.37.5
About Using BRANCH_TO_PAGE_ACCEPT
2.9.4.38
SCHEMA OWNER
2.9.4.39
SQLERRM
2.9.4.40
SYSDATE_YYYYMMDD
2.9.4.41
THEME_DB_IMAGES
2.9.4.42
THEME_IMAGES
2.9.4.43
WORKSPACE_IMAGES
2.9.4.44
WORKSPACE_ID
3
Utilizing Packaged Applications
3.1
About Packaged Applications
3.2
Managing Packaged Applications in a Full Development Environment
3.2.1
Accessing the Packaged Apps Page
3.2.2
Installing a Packaged Application
3.2.3
Running an Installed Packaged Application
3.2.4
Removing an Installed Packaged Application
3.2.5
Changing Authentication for an Installed Packaged Application
3.2.6
Unlocking an Installed Productivity Application
3.2.7
Updating a Packaged Application
3.3
Understanding Sample Database Application
3.3.1
Installing and Running Sample Database Application
3.3.2
Reviewing Sample Database Application
3.3.2.1
Home Page
3.3.2.2
About the Navigation Menu
3.3.2.3
Customers Page
3.3.2.4
Using the Customers Page
3.3.2.4.1
Editing a Customer
3.3.2.4.2
Creating a Customer
3.3.2.4.3
Uploading Data
3.3.2.5
Products Page
3.3.2.6
Using the Products Page
3.3.2.6.1
Editing a Product
3.3.2.6.2
Adding a Product
3.3.2.7
Orders Page
3.3.2.8
Using the Orders Page
3.3.2.8.1
Editing an Order
3.3.2.8.2
Placing an Order
3.3.2.9
Reports Page
3.3.2.10
Administration Page
3.3.3
Modifying Sample Database Application
3.3.3.1
Why Modify a Sample Database Application?
3.3.3.2
Editing Sample Database Application
3.4
Understanding AnyCo IT Department Websheet
3.4.1
Installing and Running AnyCo IT Department
3.4.2
Understanding Websheet Navigation
3.4.3
Understanding AnyCo IT Department
3.4.3.1
Navigating Between Pages and Viewing Page Sections
3.4.3.2
Home Page
3.4.3.3
Projects Page
3.4.3.4
Project Review Page
3.4.3.5
Systems Page
3.4.3.6
Planned Purchase Review
3.4.3.7
Systems Budget Review
3.4.4
Modifying Websheet Content
3.4.4.1
Why Modify Sample Websheet Application?
3.4.4.2
Updating a Websheet Section
3.5
Utilizing Packaged App Administration
3.5.1
Making a Service Request
3.5.2
Setting Workspace Preferences
3.5.3
Managing Users
3.5.4
Managing Saved Interactive Reports
3.5.5
Managing Interactive Report Subscriptions
3.5.6
Viewing Activity Reports
3.5.7
Viewing Page Views
3.5.8
Viewing Top Users
3.6
Using a Packaged Apps Only Workspace
3.6.1
What Is a Packaged Apps Only Workspace?
3.6.2
Requesting a Packaged Apps Only Workspace
3.6.3
Signing In To a Packaged Apps Only Workspace
3.6.4
Using the Packaged App Page
4
Managing the Application Life Cycle with Team Development
4.1
Accessing Team Development
4.2
Team Development Home Page
4.3
Tracking Features
4.3.1
Viewing the Features Report
4.3.2
Creating a Feature
4.3.3
About Feature Email Notifications
4.3.4
Updating or Deleting a Feature
4.3.5
About Creating Parent Features
4.3.6
How to Attach Files to a Feature
4.3.6.1
Attaching a File to a Feature
4.3.6.2
Viewing, Editing, and Removing Attached Files
4.3.7
Viewing Other Feature Reports
4.3.7.1
Viewing the Features Tree
4.3.7.2
Viewing the Features Calendar
4.3.7.3
Viewing The Feature History Report
4.3.7.4
Viewing the Feature Progress Log
4.3.7.5
Viewing the Feature Focus Areas Chart
4.3.7.6
Viewing the Approval Statuses
4.3.7.7
Viewing the Feature Owners Chart
4.3.8
Assigning or Updating Milestones Associated with Features
4.4
Tracking Milestones
4.4.1
Viewing the Milestones Report
4.4.2
Creating a Milestone
4.4.3
Updating or Deleting a Milestone
4.4.4
Viewing Other Milestone Reports
4.4.4.1
Viewing the Milestone Calendar
4.4.4.2
Viewing the Milestones By Owner Report
4.4.4.3
Viewing the Features by Milestone Report
4.5
Tracking To Dos
4.5.1
Viewing To Dos
4.5.2
Creating a To Do
4.5.3
Updating a To Do
4.5.4
Managing Files Attached to a To Do
4.5.4.1
Attaching a File to a To Do
4.5.4.2
Viewing, Editing, and Removing Attached Files
4.5.5
Viewing Other To Do Reports
4.5.5.1
Viewing the To Dos Calendar
4.5.5.2
Viewing the To Do Progress Log
4.6
Managing Bugs
4.6.1
Viewing Bugs
4.6.2
Creating a Bug
4.6.3
Editing a Bug
4.6.4
Managing Files Attached to a Bug
4.6.4.1
Attaching a File to a Bug
4.6.4.2
Viewing, Editing, and Removing Attached Files
4.6.5
Viewing Other Bug Reports
4.6.5.1
Viewing the Bug Calendar
4.6.5.2
Viewing the Bugs By Developer
4.6.5.3
Viewing the Bugs By Day
4.7
Managing Feedback
4.7.1
About Feedback
4.7.2
Adding Feedback Using the Create Application Wizard
4.7.3
Adding Feedback Using the Create Page Wizard
4.7.4
Submitting Feedback Within a Running Application
4.7.5
Reviewing Feedback Within an Application
4.7.6
Configuring Feedback Within an Application
4.7.7
Tracking Feedback Team in Development
4.7.7.1
Accessing the Feedback Report in Team Development
4.7.7.2
Viewing Feedback by Filing User
4.7.7.3
Viewing the Feedback Calendar
4.8
Managing Team Development Utilities
4.8.1
Accessing Team Development Utilities
4.8.2
Configuring Team Development Settings
4.8.3
Viewing a Release Summary
4.8.4
Managing Feature Utilities
4.8.5
Renaming Focus Areas
4.8.6
Downloading File Attachments
4.8.7
Purging Data
4.8.8
Managing News Entries
4.8.9
Managing Links with Workspace Members
5
Creating Websheet Applications
5.1
Creating a Websheet Application
5.1.1
Creating a Websheet from
App Builder
5.1.2
Creating a Websheet Application from a Running Websheet
5.2
Copying an Existing Websheet Page
5.3
Running a Websheet
5.3.1
Running a Websheet from the
App Builder
Home Page
5.3.2
Running a Websheet from the Application Home Page
5.3.3
Determining a Websheet URL
5.4
Editing Page Details
5.5
Understanding Websheet Properties
5.5.1
Editing Websheet Properties
5.5.2
Websheet Properties
5.5.2.1
Websheet
5.5.2.2
Details
5.5.2.3
Logo
5.5.2.4
Style
5.5.2.5
Authentication
5.5.2.6
Authorization
5.5.2.7
SQL
5.6
Deleting a Websheet Application
5.7
Viewing the Websheet Dashboard
5.8
Monitoring Websheet Activity
5.9
Controlling Websheet Access
5.9.1
How Websheet Access Works
5.9.2
Specifying the Access Control List Type
5.9.3
Creating Access Control List Entries
6
Creating Database Applications
6.1
About the Create Application Wizard
6.2
Understanding Page Types, Features, and Settings
6.2.1
About Creating a New Database Application
6.2.2
Available Page Types in the Create Application Wizard
6.2.3
Available Features in the Create Application Wizard
6.2.4
Available Settings in the Create Application Wizard
6.2.5
About Removing Features Created with the Create Application Wizard
6.3
Creating a Database Application Based on a Table or Query
6.4
Creating a Database Application from a Spreadsheet
6.4.1
About Creating an Application from a Spreadsheet
6.4.2
Loading Spreadsheet Data from a File
6.4.3
Loading Spreadsheet Data by Copying and Pasting
6.5
Using Application Blueprints
6.5.1
What Is an Application Blueprint?
6.5.2
Viewing an Application Blueprint
6.5.3
Loading an Application Blueprint
6.6
Copying a Database Application
6.6.1
Copying a Database Application Using the Create Application Wizard
6.6.2
Copying an Application from the Application Home Page
6.7
Creating Applications for Mobile Devices
6.7.1
About Mobile Application Design
6.7.2
About Mobile Support
6.7.3
Creating Mobile Applications
6.8
Deleting an Application
6.8.1
Deleting an Application from the Application Home Page
6.8.2
Deleting an Application from the Edit Application Definition Page
6.9
Managing Application Attributes
6.9.1
Editing Application Attributes
6.9.1.1
Accessing the Edit Application Definition Page
6.9.1.2
Edit Application Definition Page
6.9.1.2.1
Name
6.9.1.2.2
Properties
6.9.1.2.3
Application Icon
6.9.1.2.4
Availability
6.9.1.2.5
Error Handling
6.9.1.2.6
Global Notification
6.9.1.2.7
Substitutions
6.9.1.2.8
Build Options
6.9.2
Configuring Security Attributes
6.9.2.1
Accessing the Edit Security Attributes Page
6.9.2.2
Security Attributes Page
6.9.2.2.1
Authentication
6.9.2.2.2
Authorization
6.9.2.2.3
Session Management
6.9.2.2.4
Session State Protection
6.9.2.2.5
Browser Security
6.9.2.2.6
Database Session
6.9.3
Configuring Globalization Attributes
6.9.3.1
Accessing the Globalization Attributes Page
6.9.3.2
Edit Globalization Attributes Page
6.9.3.2.1
Application Primary Language
6.9.3.2.2
Application Language Derived From
6.9.3.2.3
Document Direction
6.9.3.2.4
Application Date Format
6.9.3.2.5
Application Date Time Format
6.9.3.2.6
Application Timestamp Format
6.9.3.2.7
Application Timestamp Time Zone Format
6.9.3.2.8
Character Value Comparison
6.9.3.2.9
Character Value Comparison Behavior
6.9.3.2.10
Automatic Time Zone
6.9.3.2.11
Automatic CSV Encoding
6.9.4
Managing the Application User Interface
6.9.4.1
Accessing User Interface Attributes
6.9.4.2
User Interface Page
6.9.4.2.1
User Interfaces
6.9.4.2.2
General Properties
6.9.4.2.3
Logo
6.9.4.2.4
Favicon
6.9.4.2.5
User Interface Detection
6.9.4.3
Defining an Application Logo
6.9.4.4
Adding Desktop UI to a Mobile UI Only Application
6.9.4.5
Editing User Interface Details
6.9.4.6
User Interface Details Page
6.9.4.6.1
Identification
6.9.4.6.2
Attributes
6.9.4.6.3
Navigation Menu
6.9.4.6.4
Navigation Bar
6.9.4.6.5
JavaScript
6.9.4.6.6
Cascading Style Sheets
6.9.4.6.7
Concatenated Files
6.10
Adding Developer Comments
6.10.1
Developer Comment, Bug, or To Do Button
6.10.2
Adding Developer Comments to an Application
6.10.3
Viewing and Editing Developer Comments
6.10.4
Deleting Developer Comments
6.10.4.1
Deleting a Specific Developer Comment
6.10.4.2
Deleting Multiple Developer Comments
6.10.5
Accessing the Developer Comments from Shared Components
6.10.6
Viewing the Developer Comments Calendar
6.11
Using the Find Icon
6.11.1
Accessing the Find Icon
6.11.2
Searching for Items
6.11.3
Searching for Pages
6.11.4
Searching for Queries
6.11.5
Searching for Tables
6.11.6
Using the PL/SQL Finder
6.11.7
Searching for Images
6.12
Adding Database Application Comments
6.13
Managing Application Groups
6.13.1
Viewing Database Application Groups
6.13.2
Creating a Database Application Group
6.13.3
Assigning a Database Application to an Application Group
6.13.4
Removing a Database Application from an Application Group
6.13.5
Deleting an Database Application Group
6.14
Using Application Utilities
6.14.1
Application Utilities
6.14.2
Accessing the Utilities Page
6.14.3
Viewing the Application Dashboard
6.14.4
Upgrading an Application to Include New Components
6.14.4.1
About Upgrading to Include New Components
6.14.4.2
Running Upgrade Application
6.14.5
Viewing the Recently Updated Pages Report
6.14.6
Viewing the Change History Report
6.14.7
Using the Database Object Dependencies Report
6.14.8
Accessing Application Express Views
6.14.9
Accessing Page Specific Utilities
6.14.10
Accessing Cross Page Utilities
6.14.11
Using Interactive Report Utilities
6.14.11.1
Deleting Saved Interactive Reports
6.14.11.2
Viewing Subscriptions
7
Managing Pages in a Database Application
7.1
About Creating New Pages
7.2
Adding a New Page to an Application
7.3
Understanding Page Types in the Create Page Wizard
7.3.1
Available Component Page Types
7.3.2
Available Features Page Types
7.3.3
Available Components for Mobile User Interface Applications
7.3.4
About Removing Features Created with the Create Page Wizard
7.4
Creating Dialog Pages
7.4.1
About Supported Dialogs
7.4.2
Using a Dialog Page Template
7.4.2.1
Creating a Dialog Page Template
7.4.2.2
About Defining Dialog Page Template Attributes
7.4.3
Defining a Dialog Page as a in Page Designer
7.4.4
Generating a Cancel Dialog Dynamic Action on the Dialog Page
7.4.5
Generating a Close Dialog Page Process on the Dialog Page
7.4.6
About Branching with Dialog Pages
7.4.7
Handling Refresh Actions on Parent Page
7.5
About Copying Database Application Pages
7.6
About Deleting Database Application Pages
7.7
Creating Page Groups
7.7.1
Viewing Page Groups
7.7.2
Creating a Page Group
7.7.3
Editing a Page Group Definition
7.7.4
Assigning a Page to a Page Group
7.7.5
Viewing Pages by Page Group
7.7.6
Deleting a Page Group
7.8
Locking and Unlocking a Page
7.8.1
Determining If a Page Is Locked
7.8.2
Locking a Page
7.8.2.1
Locking a Page from the Application Home Page
7.8.2.2
Locking a Page from the Page Locks Page
7.8.2.3
Locking a Page in Page Designer
7.8.3
Unlocking a Page
7.8.3.1
Unlocking Pages from Utilities
7.8.3.2
Unlocking Pages from the Application Home Page
7.8.3.3
Unlocking a Page in Page Designer
7.8.3.4
Unlocking Pages As a Workspace Administrator
8
Editing Pages in Page Designer
8.1
About Page Designer
8.2
Understanding Page Designer UI Elements
8.2.1
Page Designer Toolbar
8.2.2
Left Pane of Page Designer
8.2.3
Central Pane of Page Designer
8.2.3.1
Layout Tab
8.2.3.2
Gallery
8.2.3.3
Component View Tab
8.2.3.4
Messages Tab
8.2.3.5
Page Search Tab
8.2.3.6
Help Tab
8.2.4
Right Pane of Page Designer (Property Editor)
8.2.5
Code Editor
8.3
Using Page Designer
8.3.1
Viewing a Page in Page Designer
8.3.2
Searching for Pages
8.3.3
Dragging and Dropping Tabs Between Panes
8.3.4
Switching Between Three Pane and Two Pane Mode
8.3.5
Accessing Property Editor
8.3.6
Adding a Region, Item, or Button by Dragging and Dropping
8.3.7
About Adding Components Using Gallery Context Menus
8.3.8
Adding a Region, Item, or Button from the Rendering Tab
8.3.9
Adding a Region, Item, or Button from the Component View Tab
8.3.10
Copying a Region, Item, or Button
8.3.11
Creating Pre-Rendering Branches, Computations, and Processes
8.3.12
Creating Page Submission Branches, Validations, Computations, and Processes
8.4
Managing Page Attributes
8.4.1
Editing Page Attributes
8.4.2
Incorporating JavaScript Using Page Designer
8.4.3
Configuring Rejoin Sessions
8.4.4
Configuring Dialog Attributes
8.4.5
Configuring Page Attributes to Warn Users of Unsaved Changes
8.5
Running a Page from Page Designer
8.6
Runtime Developer Toolbar
8.7
Copying a Database Application Page
8.8
Deleting Pages
8.8.1
Deleting a Page
8.8.2
Deleting Multiple Pages
8.8.3
Deleting a Range of Pages
9
Developing Reports
9.1
Understanding Report Types
9.1.1
Interactive Grid
9.1.2
Interactive Report
9.1.3
Classic Report
9.1.4
Report and Form
9.2
Creating a Report Using the Create Application Wizard
9.2.1
Creating an Interactive or Classic Report Using the Create Application Wizard
9.2.2
Creating an Interactive Grid Using the Create Application Wizard
9.2.3
Report Options When Running the Create Application Wizard
9.3
Creating a Report Using the Create Page Wizard
9.3.1
Creating a Report on a New Page
9.3.2
Creating a Classic or Interactive Report on New Page Using Remote Database References
9.3.3
Report Options When Running the Create Page Wizard
9.4
Creating a Report by Dragging and Dropping from the Gallery
9.5
Managing Interactive Grids
9.5.1
Managing Interactive Grid Region Attributes
9.5.1.1
Editing Interactive Grid Region Attributes
9.5.1.2
Creating Master Detail from an Existing Interactive Grid
9.5.1.3
Displaying Interactive Grids Conditionally
9.5.2
Managing Interactive Grid Attributes
9.5.2.1
Editing Interactive Grid Attributes
9.5.2.2
Making an Existing Interactive Grid Editable
9.5.2.3
Controlling Interactive Grid Pagination
9.5.2.4
Customizing the Interactive Grid Toolbar
9.5.2.5
Enabling Users to Save Public Reports in Interactive Grids
9.5.2.6
Restricting Who Can Save Public Reports
9.5.2.7
Enabling Icon View in an Interactive Grid
9.5.2.7.1
About Icon View in an Interactive Grid
9.5.2.7.2
Adding Icon View to an Interactive Grid
9.5.2.7.3
Adding a Custom Icon View Link to an Interactive Grid
9.5.2.8
Enabling Detail View in an Interactive Grid
9.5.2.8.1
About Detail View in an Interactive Grid
9.5.2.8.2
Adding a Detail View to an Interactive Grid
9.5.3
Managing Interactive Grid Column Attributes
9.5.3.1
Editing Common Grid Column Attributes
9.5.3.2
Defining a Column as a List of Values for Filtering
9.5.3.3
Creating a Column Link in an Interactive Grid
9.5.4
About Customizing Interactive Grids in a Running Application
9.5.5
Saving Interactive Grids
9.5.5.1
How the User Type Effects Available Save Options
9.5.5.2
About Configuration Dependencies When Saving Interactive Grids
9.5.5.3
Saving a Private Interactive Grid
9.5.5.4
Saving a Public Interactive Grid
9.5.5.5
Saving or Renaming a Primary Interactive Grid
9.5.5.6
Saving an Alternative Interactive Grid
9.5.5.7
Renaming a Saved Interactive Grid Report
9.5.5.8
Deleting a Saved Interactive Grid Report
9.5.5.9
Resetting a Saved Interactive Grid Report
9.6
Managing Interactive Reports
9.6.1
Managing Interactive Report Region Attributes
9.6.1.1
Editing Interactive Report Region Attributes
9.6.1.2
Displaying Interactive Reports Conditionally
9.6.2
Managing Interactive Report Attributes
9.6.2.1
Editing Interactive Report Attributes
9.6.2.2
Managing Link Columns
9.6.2.2.1
Linking to a Single Row View
9.6.2.2.2
Linking to a Specific Page
9.6.2.2.3
Linking to a URL
9.6.2.2.4
Excluding a Link Column
9.6.2.3
Customizing the Interactive Report Search Bar
9.6.2.3.1
Interactive Report Search Bar
9.6.2.3.2
Customizing the Search Bar
9.6.2.3.3
Removing the Interactive Report Search Bar
9.6.2.4
Customizing the Actions Menu
9.6.2.5
Configuring Actions Menu Download Options
9.6.2.5.1
Enabling Download Formats
9.6.2.5.2
Enabling CSV Download
9.6.2.5.3
Enabling Email Download
9.6.2.6
Controlling Interactive Report Pagination
9.6.2.7
Enabling Icon View
9.6.2.7.1
Adding a View Icon Button
9.6.2.7.2
Adding a Custom Icon View Link
9.6.2.8
Enabling Detail View
9.6.2.9
Configuring Advanced Attributes for Interactive Reports
9.6.2.9.1
Configuring Advanced Attributes
9.6.2.9.2
About Emailing from an Interactive Report
9.6.3
Managing Interactive Report Column Attributes
9.6.3.1
Editing Interactive Report Column Attributes
9.6.3.2
Creating a Column Link in an Interactive Report
9.6.3.3
Defining a Column as a List of Values in an Interactive Report
9.6.3.4
Formatting Columns in an Interactive Report
9.6.3.5
About Filtering on Conditional Links in Interactive Report Columns
9.6.4
Customizing Interactive Reports in a Running Application
9.6.4.1
About the Search Bar
9.6.4.2
About the Actions Menu
9.6.4.3
Using Interactive Report Filters
9.6.4.4
Saving Interactive Reports
9.6.4.4.1
About the User Type and Available Save Options
9.6.4.4.2
About Configuration Dependencies
9.6.4.4.3
Saving a Public or Private Interactive Report
9.6.4.4.4
Saving a Default Interactive Report
9.6.4.4.5
Renaming a Public or Private Interactive Report
9.6.4.4.6
Deleting a Public or Private Interactive Report
9.6.4.4.7
About Exporting Interactive Reports
9.6.5
Linking to Interactive Reports
9.6.5.1
Request Syntax
9.6.5.2
Name and Value Syntax
9.6.5.3
ClearCache Syntax
9.6.5.4
Restrictions When Linking to Interactive Reports
9.6.5.5
Valid Linking Examples
9.6.5.6
Invalid Linking Examples
9.6.5.7
Linking to Shared Interactive Reports
9.6.5.7.1
Editing the Alias of Default Report in Page Designer
9.6.5.7.2
Link Examples to a Primary Report
9.6.5.7.3
Link Examples to Saved Reports
9.7
Managing Classic Reports
9.7.1
Managing Classic Report Region Attributes
9.7.1.1
Editing Classic Report Region Attributes
9.7.2
Managing Classic Report Attributes
9.7.2.1
Editing Classic Report Attributes
9.7.2.2
Editing Classic Report Pagination
9.7.2.3
Adding Support for XML File or a CSV File Export
9.7.2.4
Enabling Classic Report CSV Output Option
9.7.2.5
Controlling Classic Report Column Breaks
9.7.3
Managing Classic Report Column Attributes
9.7.3.1
Altering Classic Report Column Layout
9.7.3.2
Enabling Column Sorting in a Classic Report
9.7.3.3
Creating a Column Link in a Classic Report
9.7.3.4
Defining an Updatable Column in a Classic Report
9.7.3.5
Defining a Column as a List of Values in a Classic Report
9.7.3.6
Controlling When Classic Report Columns Display
9.7.3.7
Adding a Download Link to a Classic Report
9.8
Printing Report Regions
9.8.1
About Printing Reports to PDF
9.8.2
About Report Printing Configuration Options
9.8.3
About Classic Report Printing Methods
9.8.4
Configuring Classic Report Region Print Attributes
9.8.4.1
Configuring a Classic Report Print Attributes
9.8.5
Configuring Interactive Report Region Print Attributes
9.8.5.1
Configuring Interactive Report Regions for Printing
9.8.6
About Report Queries
9.8.7
About Report Layouts
9.9
Understanding BLOB Support in Forms and Reports
9.9.1
About BLOB Support in Reports
9.9.2
About Providing a Download Link
9.9.3
About Displaying the BLOB
9.9.4
About Working With BLOBs Procedurally
10
Developing Forms
10.1
Understanding Form Types
10.1.1
Editable Interactive Grid
10.1.2
Form on a Table
10.1.3
Master Detail Forms
10.2
Creating a Form
10.2.1
Creating a Form Using the Create Page Wizard
10.2.2
Form Options When Running the Create Page Wizard
10.2.3
Creating a Form Using the Create Application Wizard
10.2.4
Creating a Form Region
10.3
About Making an Interactive Grid Editable
10.4
Managing Master Detail Forms
10.4.1
About Master Detail Forms
10.4.2
Creating a Single Page Master Detail Using the Create Application Wizard
10.4.3
Creating a Single Page Master Detail Using the Create Page Wizard
10.4.4
Creating a Two Page Master Detail Using the Create Page Wizard
10.5
Validating User Input in Forms
10.5.1
About Creating Validations and Error Messages
10.5.2
Associating a Validation with a Specific Item
10.5.3
About the Error Message Display Location
10.6
Understanding BLOB Support in Forms
10.6.1
About BLOB Support in Forms
10.6.2
About Uploading and Downloading Files into a BLOB
10.6.3
About Displaying the BLOB
10.6.4
About Removing the Image Reference
11
Managing Database Application Components
11.1
Understanding Oracle JET Integration with Oracle Application Express
11.1.1
About Oracle JET
11.1.2
How Oracle JET is integrated with Oracle Application Express
11.2
Switching from AnyChart to JET Chart
11.2.1
Upgrading to JET Chart Using Application Upgrade Utility
11.2.2
Searching a Workspace for AnyChart Using SQL Commands
11.3
Creating Calendars
11.3.1
About Supported Calendars
11.3.2
Sample Calendar
11.3.3
Adding a Calendar to a New Page Using a Local Database
11.3.4
Adding a Calendar on a New Page Using Remote Database References
11.3.5
Creating a Calendar in Page Designer
11.3.6
Managing Calendar Attributes
11.3.6.1
Editing Calendar Attributes in the Property Editor
11.3.6.2
Editing an Existing Calendar to Include Add and Edit Functionality
11.3.6.3
Adding Calendar Initialization JavaScript Code
11.3.6.4
Enabling the Dragging and Dropping of Data In an Existing Calendar
11.3.7
About Dynamic Action Support for Calendar
11.4
Creating Maps
11.4.1
About Map Chart Support
11.4.2
About Creating SQL Queries for Maps
11.4.3
Adding a Map Chart to a New Page
11.4.4
Adding a Map Chart in Page Designer
11.4.5
Managing Map Charts
11.4.5.1
Editing Map Chart Attributes
11.4.5.2
Using Custom XML with Map Charts
11.4.5.3
Enabling Automatic Updates
11.5
Creating Charts
11.5.1
About Supported Charts
11.5.2
Sample Charts
11.5.3
Adding a Chart by Running the Create Page Wizard
11.5.4
Adding a Chart on a New Page Using Remote Database References
11.5.5
Adding a Chart in Page Designer
11.5.6
Managing Charts
11.5.6.1
Editing Chart Attributes
11.5.6.2
Switching Chart Type
11.5.6.3
Enabling Automatic Refresh
11.5.6.3.1
Enabling the Automatic Refresh Attribute
11.5.6.3.2
Creating a Refresh Dynamic Action
11.5.7
Using Custom JavaScript with Charts
11.6
Creating Help for Your Application
11.6.1
Creating Help
11.6.1.1
About Creating Help
11.6.1.2
Creating a Help Page and Region
11.6.1.3
Defining Page Help
11.6.1.4
Defining Item Help
11.6.2
Using the Bulk Edit Item Help Report
11.6.3
Seeding Item Help Topics
11.6.4
Creating a Help Navigation Bar Entry
12
Using Themes and Theme Styles
12.1
Using Themes
12.1.1
About Themes
12.1.2
About Responsive Design and the Universal Theme
12.1.3
Using Theme Styles and Theme Roller
12.1.3.1
About Theme Styles
12.1.3.2
Creating a Theme Style
12.1.3.3
Editing a Theme Style from the Themes Page
12.1.3.4
Editing a Theme Style from the User Interface Page
12.1.3.5
Enabling Users to Select a Theme Style
12.1.3.6
Using Theme Roller
12.1.4
Understanding Template Options
12.1.4.1
About Template Options
12.1.4.2
About Default Template Options
12.1.4.3
About Template Option Groups and Presets
12.1.5
Accessing the Themes Page
12.1.6
Editing Themes
12.1.6.1
Editing a Theme
12.1.6.2
Theme Attributes
12.1.6.2.1
Name
12.1.6.2.2
Theme Subscription
12.1.6.2.3
JavaScript and Cascading Style Sheets
12.1.6.2.4
Component Defaults
12.1.6.2.5
Region Defaults
12.1.6.2.6
Dialog Defaults
12.1.6.2.7
Transition Defaults
12.1.6.2.8
Global Templates Options
12.1.6.2.9
Icons
12.1.6.2.10
Image
12.1.6.2.11
Styles
12.1.6.2.12
Files
12.2
Managing Themes and Subscriptions
12.2.1
Understanding Theme Subscriptions
12.2.1.1
About Theme Subscriptions
12.2.1.2
About Modifying a Theme Subscription
12.2.1.3
Verifying if a Theme Refresh Is Needed
12.2.1.4
Refreshing a Subscribed Theme
12.2.1.5
Unsubscribing to a Theme
12.2.1.6
Re-subscribing to a Built-in Theme
12.2.2
Creating a Theme
12.2.3
Switching Themes
12.2.3.1
About Switching the Active Theme
12.2.3.2
Switching an Active Theme
12.2.4
Changing a Theme Identification Number
12.2.5
Copying a Theme
12.2.6
Deleting a Theme
12.2.7
Creating a Master Theme Application
12.2.7.1
Creating a Master Theme Application by Creating a New Application
12.2.7.2
Creating a Master Theme Application from an Existing Application
12.2.8
Managing Workspace Themes
12.2.8.1
Adding a Workspace Theme to the Theme Repository
12.2.8.2
Viewing an Existing Workspace Theme
12.2.8.3
Deleting a Workspace Theme
12.2.8.4
Modifying a Workspace Theme
12.2.8.5
Exporting a Workspace Theme
12.2.9
Managing Instance Themes
12.2.10
About Exporting and Importing Themes
12.2.11
Viewing Theme Reports
12.2.11.1
Viewing All Templates in a Theme
12.2.11.2
Viewing Theme Template Counts
12.2.11.3
Viewing File References
12.2.11.4
Viewing Class References
12.2.11.5
Viewing Template Substitution Strings
12.3
Creating Custom Themes
12.3.1
About Cascading Style Sheets
12.3.2
About Calling the JavaScript File from the Page Template
12.3.3
About Using Escaping Syntax in Substitution Strings
12.3.4
Selecting a Default Page Template
12.3.4.1
Selecting a Page-level Template Within a Theme
12.3.4.2
Selecting a Page-level Template for a Specific Page
12.3.5
Creating a New Template
12.3.6
Using Template Options
12.3.6.1
Managing Global Template Option Groups
12.3.6.1.1
Creating a Global Template Option Group
12.3.6.1.2
Editing Global Template Option Groups
12.3.6.2
Managing Global Template Options
12.3.6.2.1
Creating Global Template Options
12.3.6.2.2
Editing Global Template Options
12.3.6.3
Managing Template Options
12.3.6.3.1
Creating Template Options
12.3.6.3.2
Editing Template Options
12.3.6.3.3
Using Quick Edit to Modify Live Template Options
12.3.7
Viewing Template Reports
12.3.8
Managing Templates
12.3.8.1
Viewing Templates on the Templates Page
12.3.8.2
Viewing Templates Associated with a Specific Page
12.3.8.3
Replacing Templates
12.3.8.4
Replacing All Templates within an Application
12.3.8.5
Viewing Region Position Utilization by Page Template
12.3.8.6
Unsubscribing to Templates
12.3.8.7
Publishing Templates
12.3.9
Breadcrumb Templates
12.3.9.1
About Breadcrumb Style Navigation
12.3.9.2
Breadcrumb Template Attributes
12.3.9.2.1
Name
12.3.9.2.2
Definition
12.3.9.2.3
Substitution Strings
12.3.10
Button Templates
12.3.10.1
Button Template Attributes
12.3.10.1.1
Name
12.3.10.1.2
Definition
12.3.10.1.3
Substitution Strings
12.3.11
Legacy Calendar Templates
12.3.11.1
Supported Legacy Calendar Template Substitution Strings
12.3.11.2
Legacy Calendar Template Attributes
12.3.11.2.1
Name
12.3.11.2.2
Subscription
12.3.11.2.3
Comments
12.3.12
Label Templates
12.3.12.1
Label Template Attributes
12.3.12.1.1
Name
12.3.12.1.2
Definition
12.3.12.1.3
Error Display
12.3.12.1.4
Field Container
12.3.12.1.5
Substitution Strings
12.3.12.2
About Using #CURRENT_ITEM_HELP_TEXT# to Create Item Help
12.3.13
List Templates
12.3.13.1
About Hierarchical Lists
12.3.13.2
List Template Attributes
12.3.13.2.1
Name
12.3.13.2.2
Before List Entry
12.3.13.2.3
Template Definition
12.3.13.2.4
Template Definitions for First Entry
12.3.13.2.5
Before Sublist Entry
12.3.13.2.6
Sublist Entry
12.3.13.2.7
After Sub List Entry
12.3.13.2.8
After List Entry
12.3.13.2.9
Substitution Strings
12.3.14
Page Templates
12.3.14.1
Page Template Attributes
12.3.14.1.1
Name
12.3.14.1.2
Definition
12.3.14.1.3
JavaScript
12.3.14.1.4
Cascading Style Sheet
12.3.14.1.5
Subtemplate
12.3.14.1.6
Image Based Tab Attributes
12.3.14.1.7
Layout
12.3.14.1.8
Display Points
12.3.14.1.9
Dialog
12.3.14.1.10
Error Page Template Control
12.3.14.1.11
Substitution Strings
12.3.14.2
Required Dialog Page Template Attributes
12.3.15
Popup LOV Templates
12.3.15.1
Popup List of Values Template Attributes
12.3.15.1.1
Search Field
12.3.15.1.2
Buttons
12.3.15.1.3
Window
12.3.15.1.4
Pagination
12.3.15.1.5
Result Set
12.3.15.1.6
Page Attributes
12.3.16
Region Templates
12.3.16.1
Region Template Attributes
12.3.16.1.1
Name
12.3.16.1.2
Definition
12.3.16.1.3
Layout
12.3.16.1.4
Sub Regions
12.3.16.1.5
Substitution Strings
12.3.17
Report Templates
12.3.17.1
Generic Column Templates and Named Column Templates
12.3.17.1.1
Generic Column Templates
12.3.17.1.2
Named Column Templates
12.3.17.2
Report Column Template Attributes for Generic Column Templates
12.3.17.2.1
Report Template
12.3.17.2.2
Before Rows
12.3.17.2.3
Column Headings
12.3.17.2.4
Before Each Row
12.3.17.2.5
Column Templates
12.3.17.2.6
After Each Row
12.3.17.2.7
After Rows
12.3.17.2.8
Row Highlighting
12.3.17.2.9
Pagination Subtemplate
12.3.17.2.10
Comments
12.3.17.3
Report Column Template Attributes for Named Column Templates
12.3.17.3.1
Name
12.3.17.3.2
Subscription
12.3.17.3.3
Row Templates
12.3.17.3.4
Column Headings
12.3.17.3.5
Before first and after last row text
12.3.17.3.6
Pagination
12.3.17.3.7
Comments
12.3.17.4
About Using JavaScript in Column Templates
12.4
Using Custom Cascading Style Sheets
12.4.1
About Uploading Cascading Style Sheets
12.4.2
Referencing an Uploaded Cascading Style Sheet in the Page Template
13
Controlling Page Layout
13.1
About Page Layout in Oracle Application Express
13.2
Optimizing a Page for Printing
13.2.1
Selecting a Printer Friendly Template for an Application
13.2.2
Using f?p Syntax to Toggle to Printer Friendly Mode
13.3
Creating a Global Page to Display Components on Every Page
13.3.1
Creating a Global Page
13.3.2
Navigating to the Global Page
13.4
Managing Regions
13.4.1
About Regions
13.4.2
Creating a Region
13.4.3
Editing Regions
13.4.3.1
Editing Region Attributes
13.4.3.2
Controlling Region Positioning
13.4.3.3
Specifying a Region Header and Footer
13.4.3.4
Enabling Users to Customize a Page
13.4.3.5
Utilizing Region Caching in Page Designer
13.4.3.5.1
About Region Caching
13.4.3.5.2
Enabling Region Caching in Page Designer
13.4.3.6
Specifying a Static Region ID
13.4.3.7
Adding a Region Image
13.4.3.8
Creating a Region Display Selector
13.4.4
Copying a Region
13.4.5
Deleting Regions
13.5
About Incorporating Content from Other Web Sites
13.6
About Managing Images
13.7
Rendering HTML Using Custom PL/SQL
14
Managing Database Application Controls
14.1
Managing Page-Level Items
14.1.1
Understanding Page-Level Items
14.1.1.1
About the Differences Between Page Items and Application Items
14.1.1.2
About Item Naming Conventions
14.1.1.3
Referencing Item Values
14.1.1.4
About Referencing Items Using JavaScript
14.1.1.5
Working with Multiple Select List Item
14.1.1.5.1
About Handling Values Returned from a Multiple Select List Item
14.1.1.5.2
Using APEX_UTIL.STRING_TO_TABLE to Convert Selected Values
14.1.2
Viewing Page-Level Items
14.1.3
Creating Page-Level Items
14.1.3.1
Creating a Page-Level Item from the Rendering Tab
14.1.3.2
Adding a Page-Level Item from the Gallery
14.1.3.3
Creating a Static List of Values
14.1.3.3.1
Example 1: Four Values Displayed in Alphabetical Order
14.1.3.3.2
Example 2: Ten Values Displayed in the Order Listed
14.1.3.3.3
Example 3: A List of Values with Having Both a Return and Display Value
14.1.3.4
Creating a Cascading List of Values
14.1.3.5
Creating a Shuttle Item
14.1.3.5.1
Creating a Shuttle Item on the Form Page in Page Designer
14.1.4
Editing Page-Level Items
14.1.4.1
Editing Page Item Attributes in the Property Editor
14.1.4.2
Defining Default Values for Page Items
14.1.4.3
Configuring Page Item Security
14.1.4.4
Creating a Quick Pick Selection
14.1.4.5
Displaying Conditional Page Items
14.1.4.6
Displaying Read Only Page Items
14.1.4.7
Applying a Format Mask to an Item
14.1.4.8
Configuring Item Attributes to Warn Users of Unsaved Changes
14.1.4.9
Viewing Item Utilities
14.2
Managing Dynamic Actions
14.2.1
About Dynamic Actions
14.2.2
About Dynamic Action Events
14.2.3
Creating a Dynamic Action
14.2.4
Editing Dynamic Actions
14.2.5
Defining Dynamic Action Event Scope
14.2.6
Deleting a Dynamic Action
14.2.7
About Calling JavaScript Using a Dynamic Action
14.2.8
Debugging Dynamic Actions
14.2.8.1
About Debugging Dynamic Actions
14.2.8.2
Debugging Dynamic Actions
14.3
Managing Buttons
14.3.1
What Actions Can a Button Perform?
14.3.2
Creating a Button
14.3.3
Editing a Button
14.3.4
Displaying a Button Conditionally
14.3.5
Configuring Button Attributes to Warn Users of Unsaved Changes
14.3.6
About Calling JavaScript from a Button
14.3.7
About the Relationship Between Button Names and REQUEST
14.3.8
About Branching with Buttons
14.4
Managing Trees
14.4.1
About Trees
14.4.2
Creating a Tree on New Page
14.4.3
Creating a Tree in Page Designer
14.4.4
Editing Tree Attributes
14.5
About Incorporating JavaScript into an Application
15
Adding Navigation
15.1
About Using Lists as Navigation
15.2
Creating Tabs
15.2.1
About Tabs
15.2.2
About the Tabs Page
15.2.3
Checking for Tab Template Support
15.2.4
Creating a Tab
15.2.5
Editing Tabs
15.2.5.1
Editing Multiple Tabs Simultaneously
15.2.5.2
Managing Standard Tabs
15.2.6
Accessing Tab Reports
15.3
Creating Breadcrumbs
15.3.1
What Are Breadcrumbs?
15.3.2
Creating a Breadcrumb While Creating a Page
15.3.3
Creating a Breadcrumb Manually
15.3.3.1
About Creating a Breadcrumb Manually
15.3.3.2
Creating Breadcrumbs as Shared Components
15.3.3.3
Creating a Breadcrumb Region Using the Create Breadcrumb Wizard
15.3.3.4
Adding a Breadcrumb Region to a Page
15.3.3.5
Adding Entries to a Breadcrumb
15.3.3.6
About Creating Dynamic Breadcrumbs
15.3.4
Editing Breadcrumbs
15.3.5
Reparenting Breadcrumb Entries
15.3.6
Deleting Unused Breadcrumb Entries
15.3.7
Accessing Breadcrumb Reports
15.4
Creating Classic Navigation Bar
15.4.1
About Classic Navigation Bar Entries
15.4.2
Creating a Classic Navigation Bar Entry
15.4.2.1
Creating a Classic Navigation Bar Entry from Scratch
15.4.2.2
Creating a Classic Navigation Bar Entry for Feedback
15.4.3
Copying a Classic Navigation Bar Entry
15.4.4
Editing a Classic Navigation Bar Entry
15.4.5
Editing Multiple Classic Navigation Bar Entries Simultaneously
15.4.6
Accessing Classic Navigation Bar Entry Reports
15.5
Controlling Navigation Using Branches
15.5.1
Creating a Branch
15.5.2
About Branching Conditionally
16
Managing Computations, Validations, and Processes
16.1
Understanding Page Computations
16.1.1
About Page Computations
16.1.2
Creating a Page Computation
16.1.3
Editing Page Computation Attributes
16.1.4
Editing the Computation Point and Source
16.1.5
Computation Points and Computation Syntax Example
16.2
Understanding Validations
16.2.1
About Validations
16.2.2
Creating a Validation
16.2.3
Editing a Validation
16.2.4
About Determining When Validations Execute
16.2.5
About Defining How Validation Error Messages Display
16.2.6
Processing Validations Conditionally
16.2.7
About Altering the Go to Error Link
16.2.8
What Happens When a Validation Fails?
16.3
Understanding Page Processes
16.3.1
About Page Processes
16.3.2
Creating Page Processes
16.3.3
Editing Page Process Attributes
16.3.4
Controlling When a Page Process Executes
16.3.5
Creating Page Process Success and Error Messages
16.3.6
Making a Page Process Conditional
16.4
About Branches
16.5
Understanding Application Processes
16.5.1
On Demand Application Processes
16.5.2
About Application Processes that Execute On New Instance
16.5.3
About Running an On Demand Process from a Page Request
16.5.4
Application Process Example
16.5.5
Creating an Application Process
16.5.6
Editing Application Process Attributes
16.5.7
Creating Application Process Error Messages
16.5.8
Viewing the Application Processes History Report
16.6
Understanding Application Computations
16.6.1
About Application Computations
16.6.2
About Application Computations that Execute On New Instance
16.6.3
Creating an Application Computation
16.6.4
Accessing the Application Computation History Report
16.7
Using the Attribute Dictionary
16.7.1
About the Attribute Dictionary
16.7.2
Accessing the Manage Attribute Dictionary
17
Managing Shared Components
17.1
Accessing the Shared Components Page
17.2
Shared Components Page
17.2.1
Application Logic
17.2.2
Security
17.2.3
Other Components
17.2.4
Navigation
17.2.5
User Interface
17.2.6
Files
17.2.7
Data Sources
17.2.8
Reports
17.2.9
Globalization
17.2.10
Tasks Region
17.2.11
Workspace Objects Region
17.3
Managing Application Settings
17.3.1
Creating an Application Setting
17.3.2
Editing or Deleting Application Setting
17.4
Creating Lists of Values at the Application Level
17.4.1
What is a List of Values?
17.4.2
Creating a Named LOV at the Application Level
17.4.3
About Static LOVs
17.4.4
Editing an Existing LOV
17.4.4.1
Editing a LOV
17.4.4.2
Editing LOVs in Bulk
17.4.5
About Referencing Session State Within an LOV
17.4.6
Accessing LOV Reports
17.5
Managing Component Settings
17.5.1
Configuring Component Settings
17.5.2
Integrating with Google Calendar
17.5.3
Configuring Color Picker Display
17.5.4
Configuring Interactive Report Action Menu Structure
17.5.5
Dynamically Adding Sliders to Regions
17.5.6
Configuring Switch Defaults
17.5.7
Configuring Rich Text Editor Responsiveness
17.5.8
Viewing the Component Settings History Report
17.6
Using Shortcuts
17.6.1
What is a Shortcut?
17.6.2
Supported Shortcut Types
17.6.3
Defining a Shortcut from Scratch
17.6.4
Copying an Existing Shortcuts
17.6.5
Editing Existing Shortcuts
17.6.6
Accessing Shortcut Reports
17.7
Managing Email Templates
17.7.1
Defining an Email Template
17.7.2
Viewing Sample Email Templates
17.7.3
About Including Dynamic Text
17.7.4
Editing Email Templates
17.8
Managing Static Application Files
17.8.1
Specifying the Location of Static Application Files
17.8.2
Uploading Static Application Files
17.8.3
Viewing the Static Application File Report
17.8.4
Referencing Static Application Files
17.8.5
Downloading Static Application Files
17.8.5.1
Downloading a Static Application File
17.8.5.2
Downloading All Static Application Files in a Zip
17.8.6
Deleting Static Application Files
17.8.6.1
Deleting a Static Application File
17.8.6.2
Deleting All Static Application Files
17.9
Managing Static Workspace Files
17.9.1
Uploading Static Workspace Files
17.9.2
Viewing Static Workspace File Report
17.9.3
About Referencing Static Workspace Files
17.9.4
Downloading Static Workspace Files
17.9.4.1
Downloading a Static Workspace File
17.9.4.2
Downloading All Static Workspace Files in a Zip
17.9.5
Deleting Static Workspace Files
17.9.5.1
Deleting a Static Workspace File
17.9.5.2
Deleting All Static Workspace Files
17.10
Managing Application-Level Items
17.10.1
Creating an Application-Level Item
17.10.2
Viewing Application Item Usage
17.10.3
Editing Application-Level Item Attributes
17.10.4
About Creating an Application-Level Item that Functions as a Global Variable
17.11
Creating Lists
17.11.1
About Static and Dynamic Lists
17.11.2
Creating Static Lists
17.11.2.1
About the Process of Creating a Static List
17.11.2.2
Creating a Static List from Scratch
17.11.2.3
About Adding Entries and Sublists to a Static List
17.11.2.4
Adding Entries or Sublists from Scratch
17.11.2.5
Copying Static List Entries Between Lists
17.11.2.6
Reparenting Static List Entries
17.11.2.7
Managing Orphaned Static List Entries
17.11.2.8
Resequencing Static List Entries
17.11.3
Creating Dynamic Lists
17.11.3.1
About the Process of Creating a Dynamic List
17.11.3.2
Understanding Dynamic List Syntax
17.11.3.3
Creating a Dynamic List from Scratch
17.11.4
Copying a List
17.11.4.1
Copying a List from the Current Application
17.11.4.2
Copying a List Between Applications
17.11.5
Adding a List to a Page
17.11.6
Editing List Attributes
17.11.7
Accessing List Reports
17.11.8
Managing Navigation Menus
17.11.8.1
About Navigation Menus
17.11.8.2
Editing Navigation Menu Lists
17.11.8.3
Changing Where and How Navigation Menus Display
17.11.8.4
About Switching from Tabs to Navigation Menus
17.11.9
Managing Navigation Bar Lists
17.11.9.1
About Navigation Bars
17.11.9.2
Editing Navigation Bar Lists
17.11.9.3
Editing Navigation Bar User Interface Details
17.12
Managing Report Output
17.12.1
Printing a Report Region by Defining a Report Query
17.12.1.1
About Report Queries
17.12.1.2
Creating a Report Query
17.12.1.3
Editing a Report Query
17.12.1.4
Copying a Report Query
17.12.2
Formatting a Report Region or Report Query Using Report Layouts
17.12.2.1
About Report Layouts
17.12.2.2
About Report Layout Options
17.12.2.3
Creating a Report Layout
17.12.2.4
Editing a Report Layout
17.12.2.5
Copying a Report Layout
18
Managing Application Data
18.1
Creating Applications with Data Loading Capability
18.1.1
About Creating a Data Load Wizard
18.1.2
Creating a Data Load Wizard
18.1.3
Re-creating Data Load Pages
18.1.4
Editing the Data Load Definition
18.2
About Using Collections
18.3
Managing REST Enabled SQL References
18.3.1
About REST Enabled SQL Service
18.3.2
Before You Begin: REST Enabled SQL Service Requirements
18.3.3
Creating a REST Enabled SQL Service Reference
18.3.4
Example: Creating a REST Enabled SQL Service Reference
18.3.5
Editing a REST Enabled SQL Service Reference
18.3.6
Deleting a REST Enabled SQL Service Reference
18.3.7
Creating or Updating Components to Use a REST Enabled SQL
18.3.7.1
Creating an Interactive or Classic Report Using a REST Enabled SQL Reference
18.3.7.2
Creating a Chart Using a REST Enabled SQL Reference
18.3.7.3
Creating a Calendar Using a REST Enabled SQL Reference
18.3.7.4
Specifying a REST Enabled SQL Reference in an Existing Component
18.4
Managing Web Source Modules
18.4.1
About Web Source Modules
18.4.2
Creating a Web Source Module
18.4.3
Editing or Deleting a Web Source Module
18.4.4
Copying a Web Source Module
18.4.5
Viewing Credential Utilization
18.4.6
Viewing Web Service Module History
18.5
Managing Remote Servers
18.5.1
About Remote Servers
18.5.2
Creating a Remote Server
18.5.3
Editing or Deleting a Remote Server
18.5.4
Viewing Remote Server Utilization
18.5.5
Viewing Remote Server History
18.6
Managing Web Credentials
18.6.1
About Credentials
18.6.2
Creating Web Credentials
18.6.3
Editing or Deleting Credentials
18.6.4
Viewing Credential Utilization
18.6.5
Viewing Credential History
18.7
Managing Legacy Web Services
18.7.1
About Web Services
18.7.2
Creating Web Service References
18.7.2.1
Accessing the Web Service References Page
18.7.2.2
Specifying an Application Proxy Server Address
18.7.3
About Working with SSL Enabled Web Services
18.7.4
Creating Web Service References Based on a WSDL
18.7.4.1
About Creating Web Service References Based on a WSDL
18.7.4.2
Creating a Web Service Reference by Specifying a WSDL Document
18.7.4.3
Testing a Web Service Reference Created from a WSDL
18.7.5
Creating Web Service References Manually
18.7.5.1
About Creating Web Service References Manually
18.7.5.2
Creating a Web Service Reference Manually
18.7.5.3
Testing a Web Service Reference Created Manually
18.7.6
Creating RESTful Web Service References
18.7.6.1
About Creating RESTful Web Service References
18.7.6.2
Creating a RESTful Web Service Reference
18.7.6.3
Testing a REST Web Service Reference
18.7.7
Using the Web Service Reference Repository
18.7.8
Creating an Input Form and Report on a Web Service
18.7.8.1
About the Create Form and Report on Web Service Wizard
18.7.8.2
Creating a Form and Report by Adding a New Page
18.7.9
Creating a Form on a Web Service
18.7.9.1
About the Create Form on Web Service Wizard
18.7.9.2
Creating a Form by Adding a New Page
18.7.10
Creating a Report on a Web Service
18.7.11
How to Invoke a Web Service as a Process
18.7.11.1
Invoking a Web Service as a Process
18.7.11.2
Editing a Web Service Process
18.7.12
Viewing a Web Service Reference History
18.8
Accessing Data with Database Links
18.8.1
About Database Links
18.8.2
Creating a Database Link
18.8.3
Viewing an Existing Database Link
18.9
About DML Locking
18.9.1
About DML Locking
18.9.2
APEX_DML_LOCK_WAIT_TIME
18.9.3
FSP_DML_LOCK_ROW
19
Extending Application Capabilities
19.1
Sending Email from an Application
19.1.1
About Configuring Email
19.1.1.1
About Enabling Network Services
19.1.1.2
About Configuring Email in a Full Development Environment
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
Accessing the Plug-ins Page
19.2.3
Creating a Plug-in
19.2.4
Editing a Plug-in
19.2.5
Adding Custom Attributes to a Plug-in
19.2.6
Uploading Files Associated with a Plug-in
19.2.6.1
Uploading a File to Associate with a Plug-in
19.2.6.2
Automatically Loading CSS and JavaScript Files
19.2.7
Adding Events to a Plug-in
19.2.8
Deleting a Plug-in
19.2.9
Viewing the Plug-in Repository
19.2.10
Importing a Plug-in from the Plug-in Page
19.2.11
Exporting a Plug-in from the Plug-in Page
19.2.12
Resetting the Plug-in Interactive Report
19.2.13
Viewing Plug-in Utilization Page
19.2.14
Viewing Plug-in History
19.3
Understanding jQuery and jQuery UI Support
19.3.1
About Upgrading to jQuery 3.1.1
19.3.2
About Upgrading to jQuery UI 1.12.x
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.5.1
About Creating Login Controls
20.1.5.2
About Enabling Public File Upload
20.1.5.3
About Restricting User Access by IP Address
20.1.5.4
About Specifying an Instance Proxy
20.1.5.5
About Utilizing Secure Sockets Layer
20.1.5.6
About Enabling RESTful Access
20.1.5.7
About Rejoin Sessions
20.1.5.8
About Isolating Workspaces
20.1.5.9
About Utilizing Session Timeout
20.1.5.10
Restricting Password Reuse
20.1.5.11
About Using SQL in Websheets
20.1.5.12
About Enabling RESTful Services
20.1.6
Configuring Instance Settings
20.1.6.1
About Enabling Automation When Creating Workspaces
20.1.6.2
About Enabling and Configuring Email
20.1.6.3
About Configuring Storage Options
20.1.6.4
About Creating Wallets
20.1.7
About Configuring Workspace Purge Settings
20.1.8
Understanding Workspace Management
20.1.8.1
About Managing Workspace to Schema Assignments
20.1.8.2
About Managing Developers and Users
20.1.8.3
About Managing Component Availability
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.1.11.1
When and Why Network Services Must be Enabled
20.1.11.2
Granting Connect Privileges Prior to Oracle Database 12
c
20.1.11.3
Granting Connect Privileges in Oracle Database 12
c
or Later
20.1.11.4
Troubleshooting an Invalid ACL Error
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.2.1
Viewing the Security Profiles Report
20.2.2.2
Viewing the Password Items Report
20.2.3
Understanding Cross-Site Scripting Protection
20.2.3.1
What Is Cross Site-scripting Security Breach?
20.2.3.2
Protecting HTML Regions and Other Static Areas
20.2.3.2.1
About Protecting HTML Regions and Other Static Areas
20.2.3.2.2
About Safe Item Display Types
20.2.3.2.3
About the Rules Used to Determine Whether to Escape Values
20.2.3.2.4
About Using Safe Item Types to Hold and Emit HTML Markup
20.2.3.3
About Protecting Dynamic Output
20.2.3.4
About Protecting Report Regions
20.2.3.5
About Protecting Form Items
20.2.3.6
About Restricting Characters Entered on an Item
20.2.4
About Session State and Security
20.2.5
Preventing URL Tampering
20.2.5.1
How Session State Protection Works
20.2.5.2
Enabling Session State Protection
20.2.5.2.1
Enabling Session State Protection from Edit Security Attributes
20.2.5.2.2
Enabling Session State Protection from Session State Protection
20.2.5.3
Configuring Session State Protection
20.2.5.3.1
About Configuring Session State Protection
20.2.5.3.2
Reviewing Existing Session State Protection Settings
20.2.5.3.3
Configuring Session State Protection Using a Wizard
20.2.5.3.4
Configuring Session State Protection for Pages
20.2.5.3.5
Configuring Session State Protection for Page Items
20.2.5.3.6
Configuring Session State Protection for Application Items
20.2.6
About Securing File Uploads
20.3
Controlling Access to Applications, Pages, and Page Components
20.3.1
Understanding Access Control
20.3.1.1
About Adding Access Control
20.3.1.2
About Access Control Authorization Schemes
20.3.1.3
About Configuring Access Control
20.3.1.4
About Exporting an Application with Access Control
20.3.2
Creating an Access Control Using the Create Application Wizard
20.3.3
Creating an Access Control Using the Create Page Wizard
20.3.4
Managing User Access
20.3.5
Configuring Access Control
20.3.6
About Controlling Access for Pages and Page Components
20.3.7
About Removing an Access Control Created with a Wizard
20.3.8
Managing Roles and User Assignments
20.3.8.1
About Application Access Control
20.3.8.2
Creating Access Control Roles
20.3.8.3
Editing or Deleting Access Control Roles
20.3.8.4
Adding User Role Assignments
20.3.8.5
Editing User Role Assignments
20.4
Establishing User Identity Through Authentication
20.4.1
Understanding Authentication
20.4.1.1
How Authentication Works
20.4.1.2
About Support for Deep Linking
20.4.1.3
About Determining Whether to Include Authentication
20.4.2
Creating an Authentication Scheme
20.4.3
Understanding Preconfigured Authentication Schemes
20.4.3.1
Application Express Accounts
20.4.3.1.1
About Application Express Accounts
20.4.3.1.2
Setting Up Application Express Accounts Authentication
20.4.3.2
Custom Authentication
20.4.3.2.1
About Custom Authentication
20.4.3.2.2
Setting Up Custom Authentication
20.4.3.2.3
About Session Management Security
20.4.3.3
Database Accounts
20.4.3.3.1
About Database Account Credentials
20.4.3.3.2
Setting Up Database Account Credentials
20.4.3.4
HTTP Header Variable
20.4.3.4.1
About HTTP Header Variable
20.4.3.4.2
Setting Up HTTP Header Variable
20.4.3.5
LDAP Directory Verification
20.4.3.5.1
About LDAP Directory Verification
20.4.3.5.2
Setting Up LDAP Directory Verification
20.4.3.6
No Authentication (using DAD)
20.4.3.6.1
About DAD Credentials Verification
20.4.3.6.2
Setting Up DAD Credentials Verification
20.4.3.7
Open Door Credentials
20.4.3.7.1
Setting Up Open Door Credentials
20.4.3.8
Oracle Application Server Single Sign-On Server
20.4.3.8.1
About Application Server Single Sign-On Server
20.4.3.8.2
Setting Up Oracle Application Server Single Sign-On
20.4.3.9
Social Sign-In
20.4.3.9.1
About Social Sign-In
20.4.3.9.2
Setting Up Social Sign-In Authentication
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.2.1
About Authorization Scheme Types
20.5.2.2
Creating an Authorization Scheme
20.5.2.3
Editing Attributes of an Existing Authorization Scheme
20.5.2.4
Changing the Evaluation Point Attribute
20.5.2.5
About Resetting Authorization Scheme State
20.5.3
Attaching an Authorization Scheme to an Application, Page, or Components
20.5.3.1
Attaching an Authorization Scheme to an Application
20.5.3.2
Attaching an Authorization Scheme to a Page
20.5.3.3
Attaching an Authorization Scheme to a Control or Component
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.1.5.1
About Shortcuts that Support Translatable Messages
21.1.5.2
About Messages
21.1.5.3
About Dynamic Translation Text Strings
21.1.5.4
About Translating Region Titles
21.1.5.4.1
Marking a Region as Not Translatable in Page Designer
21.1.5.5
About Translating Templates
21.2
Specifying the Primary Language for an Application
21.3
About Apply Format Masks to Items
21.4
About Translating Applications for Multibyte Languages
21.5
Understanding the Translation Process
21.5.1
Step 1: Define Application Language
21.5.2
Step 2: Seed and Download to a Translation File
21.5.2.1
Seeding Translatable Text
21.5.2.2
Downloading an XLIFF File
21.5.2.2.1
About the XLIFF Export Page
21.5.2.2.2
Downloading a XLIFF file for an Application
21.5.2.2.3
Downloading an XLIFF File for an Application Page
21.5.2.2.4
About Including XLIFF Target Elements
21.5.3
Step 3: Translate the XLIFF File
21.5.4
Step 4: Upload and Apply a Translated XLIFF Document
21.5.4.1
Uploading a Translated XLIFF Document
21.5.4.2
Applying an Uploaded XLIFF Document
21.5.4.3
Deleting an Uploaded XLIFF Document
21.5.5
Step 5: Publish the Application
21.5.6
Manually Editing a Translation
21.6
Translating Messages
21.6.1
About Translating Messages
21.6.2
Translating Messages Used in PL/SQL Procedures
21.6.2.1
About Translating Messages Used in PL/SQL Procedures
21.6.2.2
Defining a Translation Message
21.6.3
Interactive Grid Messages Requiring Translation
21.6.4
Translating Messages Used Internally by Oracle Application Express
21.6.4.1
Creating Text Messages
21.6.4.2
Editing Text Messages
21.6.4.3
Internal Messages Requiring Translation
21.6.4.4
Interactive Report Messages Requiring Translation
21.7
Translating Data That Supports List of Values
21.7.1
Defining a Dynamic Translation
21.8
Understanding Supported Globalization Codes
21.8.1
Oracle Application Express Globalization Codes
22
Managing Application Performance
22.1
About Best Practices to Improve Performance
22.2
Identifying Performance Issues
22.2.1
About Troubleshooting Slow Running Applications
22.2.2
Diagnosing Performance Issues
22.2.3
About Debugging Problematic SQL Queries
22.2.4
About Addressing Slow Queries
22.3
Utilizing Logs and Reports
22.3.1
How to Manage Log Files
22.3.2
Viewing the Application Dashboard Report
22.3.3
Workspace Activity Reports
22.3.4
Instance Activity Reports
22.4
About Utilizing Database Reporting
22.5
About Database Parameters that Impact Performance
22.6
About Limiting Resources
22.7
About Uploading Static Files to Your Web Server
22.8
Creating Custom Activity Reports Using APEX_ACTIVITY_LOG
22.8.1
Enabling Logging for an Application
22.8.2
APEX_ACTIVITY_LOG
22.8.3
APEX_ACTIVITY_LOG Sample Query
23
Debugging an Application
23.1
Running Advisor to Check Application Integrity
23.1.1
About Oracle Application Express Advisor
23.1.2
Running Advisor on an Entire Application
23.1.3
Running Advisor on a Single Page
23.2
Reviewing Session State
23.3
About Monitoring Application and Page Resource Use
23.4
Enabling SQL Tracing and Using TKPROF
23.5
Utilizing Debug Mode
23.5.1
About Debug Mode
23.5.2
Enabling and Disabling Debug Mode for an Application
23.5.3
Running an Application in Debug Mode
23.5.4
Viewing Debug Reports in Development Mode
23.5.5
About Using f?p Syntax to Access Debug Mode
23.5.6
Viewing Debug Reports from a Running Application
23.5.7
Viewing Debug Reports
23.6
About Removing Controls and Components to Isolate a Problem
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
How to Move an Application to Another Instance
24.3.3.1
About Managing Database Objects
24.4
How to Create a Custom Packaged Application
24.4.1
How Creating a Custom Packaged Application Simplifies Deployment
24.4.2
Creating a Custom Packaged Application
24.4.2.1
Accessing the Supporting Objects Page
24.4.2.2
Supporting Objects Page
24.4.2.2.1
Installation
24.4.2.2.2
Upgrade
24.4.2.2.3
Deinstallation
24.4.3
Adding an Access Control List to a Custom Packaged Application
24.4.4
Installing Supporting Objects
24.4.5
Deleting Supporting Objects Scripts, Messages, and Installation Options
24.4.6
Upgrading a Custom Packaged Application
24.4.6.1
Defining an Upgrade Script
24.4.6.2
Upgrading a Custom Packaged Application
24.4.7
Deinstalling Supporting Objects
24.4.8
Viewing an Install Summary
24.5
Using Build Options to Control Configuration
24.5.1
About Build Options
24.5.2
Creating Build Options
24.5.3
Including or Excluding Build Options
24.5.4
Selecting a Build Option
24.5.5
Deleting Build Options and Associated Components
24.5.5.1
Removing Components Associated with a Build Options
24.5.5.2
Deleting Build Options Permanently
24.5.6
Viewing Build Option Reports
24.5.6.1
Viewing Build Option Utilization
24.5.6.2
Viewing Build Option History
24.5.7
Exporting Build Options or Build Option Status
24.6
About Publishing the Database Application URL
24.7
About Publishing the Websheet Application URL
24.8
Exporting an Application and Application Components
24.8.1
About the Export Process
24.8.2
About The Export Page
24.8.3
Exporting an Application
24.8.4
Exporting Application Components
24.8.5
Exporting a Workspace
24.8.6
Exporting a Page in an Application
24.8.6.1
Exporting a Websheet
24.8.7
About Exporting Static Files
24.8.8
Exporting Themes
24.8.9
Exporting Plug-ins
24.8.10
Exporting User Interface Defaults
24.8.10.1
About Exporting User Interface Defaults
24.8.10.2
Exporting User Interface Defaults from the Export Page
24.8.10.3
Exporting User Interface Defaults from the User Interface Defaults Page
24.8.11
Exporting Team Development Feedback
24.8.12
Exporting Script Files from the Script Repository
24.9
Importing Export Files
24.9.1
Importing an Application, Page or Component Export
24.9.2
About Importing Application Groups
24.9.3
Importing a Websheet
24.9.4
Importing Plug-ins
24.9.5
Importing Themes
24.9.6
Importing User Interface Defaults
24.9.7
Importing Team Development Feedback
24.10
Installing Export Files
24.10.1
About Installing Export Files
24.10.2
Accessing the Export Repository
24.10.3
Installing an Application Export from the Export Repository
24.10.4
Installing Other Files from the Export Repository
24.10.5
Deleting Files from the Export Repository
24.10.6
Installing Export Files from SQL*Plus
24.10.7
Using SQL*Plus to Install Export Files
25
Managing Application Legacy Components
25.1
Managing Legacy Charts
25.1.1
About Chart Legacy Types
25.1.1.1
About Legacy HTML5 Charts
25.1.1.2
About Legacy Flash Charts
25.1.2
Creating SQL Queries for Legacy Charts
25.1.2.1
Legacy Chart Syntax
25.1.2.2
Dial Chart Syntax (Flash and HTML5)
25.1.2.3
Legacy Multiple Series Syntax (Flash and HTML5)
25.1.2.4
Legacy Range Chart Syntax (Flash and HTML5)
25.1.2.5
Legacy Scatter Chart Syntax (Flash and HTML5)
25.1.2.6
Legacy Candlestick Chart Syntax (Flash and HTML5)
25.1.2.7
Legacy Gantt Chart Syntax (Flash Only)
25.1.3
Adding a Legacy Chart to a New Page
25.1.4
Adding a Legacy Chart in Page Designer
25.1.5
Editing Legacy Charts
25.1.5.1
Editing Chart Attributes
25.1.5.2
Switching an HTML5 Chart to a Flash Chart
25.1.5.3
Enabling Asynchronous Updates
25.1.5.3.1
Enabling the Asynchronous Update Attribute
25.1.5.3.2
Creating a Refresh Dynamic Action in Page Designer
25.1.6
About Saving Flash Charts
25.1.7
Using Custom XML with Flash and HTML5 Charts
25.2
Creating a Legacy Master Detail Form
25.3
Managing Legacy Tabular Forms
25.3.1
About Creating Tabular Forms
25.3.2
About Running a Tabular Form
25.3.3
How Tabular Forms Work
25.3.4
Creating a Legacy Tabular Form
25.4
Managing Legacy Calendars
25.4.1
Editing Calendar Attributes in the Property Editor
25.4.2
About Supported Calendar Substitution Strings in Legacy Calendars
25.5
Viewing Legacy Components in Gallery
A
About Item Types
A.1
Available Item Types
B
Oracle Application Express Limits
B.1
Component Limits
C
Available Conditions
C.1
What Are Conditions?
C.2
Conditions Available in
App 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
Index
Scripting on this page enhances content navigation, but does not change the content in any way.