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