Contents

      Title and Copyright Information

Preface

• Topic Overview
• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in Oracle Application Express

• Oracle Application Express Release 3.0 New Features

Part I Getting Started with Oracle Application Express

1 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

2 Running a Demonstration Application

• Installing a Demonstration Application
• Running an Installed Demonstration Application
  • Running an Application from Demonstration Applications
  • Running an Application from the Application Home Page
• Understanding Sample Application
  • About the Home Page
  • About the Customers Page
  • About the Products Page
  • About the Orders Page
  • About the Charts Page
  • About the Admin Page
  • Viewing Pages in Printer Friendly Mode
• Modifying a Demonstration Application
  • About the Developer Toolbar
  • Editing a Demonstration Application
• Viewing Underlying Database Objects
  • Viewing the Database Object Dependencies Report
  • Viewing Database Objects in Object Browser

Part II Application Development

3 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
  • What Is a Session?
  • Understanding Session IDs
  • Viewing Session State
• Managing Session State Values
  • Referencing Session State
  • Setting Session State
  • Clearing Session State
  • 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

4 Using Application Builder

• Accessing Application Builder
• About the Application Builder Home Page
  • Configuring Developer Preferences
• About the Application Home Page
  • About the Action Bar
• About Application Attributes
  • Configuring the Application Definition
  • Configuring Security Attributes
  • Configuring Globalization Attributes
• About the Page Definition
  • Accessing a Page Definition
  • Understanding 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
  • Understanding Validations
  • Understanding Page Processes
  • Understanding Branches
• Editing Page Attributes
  • Accessing Page Attributes
  • About the Page Attributes Page
• About the Developer Toolbar
• Working with Shared Components
  • Accessing the Shared Components Page
  • About the Shared Components Page
  • About Exporting Shared Components
  • 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
  • Accessing Application Reports
  • Shared Components Reports
  • Page Components Reports
  • Activity Reports
  • Cross Application Reports

5 Building an Application

• Creating an Application
  • About Creating an Application Using a Wizard
  • About the Create Application Wizard
  • 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
  • Grouping Pages
  • Locking and Unlocking a Page
  • Deleting a Page
• Adding Application Comments
  • Creating an Application Comment
  • Viewing the Application Comments Report
• Adding Developer Comments
  • Adding Developer Comments to an Application or Page
  • Viewing and Editing Developer Comments
  • 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
  • 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
  • Printing Report Regions
• Creating Forms
  • Creating a Form Using a Wizard
  • Creating a Tabular Form
  • Creating a Master Detail Form
  • Creating a Form Manually
  • 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
  • Creating a Flash Chart
  • 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
  • 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
  • Editing Page-Level Items
  • Using the Drag and Drop Layout Page
  • 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
  • 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
  • About Shortcut Types
  • Defining Shortcuts
  • Editing Existing Shortcuts
  • Accessing Shortcut Reports
• 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
  • Selecting an Application Mode and Adding Users
  • Controlling Access for Pages and Page Components
• Incorporating JavaScript into an Application
  • Referencing Items Using JavaScript
  • Incorporating JavaScript Functions
  • Calling JavaScript from a Button
• Creating a Help Page
  • Creating a Help Page and Region
  • Defining Help Text
  • Creating a Help Navigation Bar Entry

6 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
  • 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
  • How To Create a Tree
  • Editing a Tree
  • Accessing Tree Reports
• 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

7 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
  • Creating a Region
  • About Region Types
  • Copying a Region
• Creating a Multiple Column Layout
  • Creating Regions in Multiple Columns
  • Creating a Multiple Column Page Template
• How Item Attributes Affect Page Layout
• Incorporating Content from Other Web Sites
• Managing Themes
  • Accessing the Themes Page
  • 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
  • Uploading Cascading Style Sheets
  • Referencing an Uploaded Cascading Style Sheet in the Page Template
• Managing Images
  • Uploading Images
  • Referencing Images
  • Editing Image Attributes
  • Deleting an Image
• Managing Static Files
  • Uploading Static Files
  • Editing an Uploaded File
  • Downloading an Uploaded File
  • Deleting an Uploaded File
• Rendering HTML Using Custom PL/SQL

8 Understanding Application Administration

• Understanding Administrator Roles
• About the Application Administration Page
  • Accessing the Application Administration Page
  • Resetting Your Password from Application Administration
  • Viewing the Application Express Product Information Page
• About the Manage Services Page
  • Accessing the Manage Services Page
• Managing Session State and User Preferences
  • Managing Session State
  • Managing User Preferences
• Managing Cached Regions and Pages
  • Purging Cached Regions
  • Purging Cached Pages
• Managing Workspace Preferences
  • Disabling PL/SQL Program Unit Editing for a Workspace
  • Enabling Login Controls for a Workspace
• Managing Application Models
  • Deleting an Application Model
• Managing Demonstration Applications
• Leveraging Application Builder Defaults
  • About Application Builder Defaults
  • Configuring Application Builder Defaults
• Viewing the Workspace Overview Report
  • Viewing Workspace Summary Report
  • Viewing Available Storage Space
• Terminating a Workspace Service
• Requesting a Database Schema
• Requesting Additional Storage
• Viewing Schema Reports
• Managing Log Files
  • Purging the Developer Activity Log
  • Purging the External Click Count Log
• Managing Application Express Users
  • Creating New User Accounts
  • Editing Existing User Accounts
  • Deleting or Locking User Accounts
  • Changing an End User Password
  • Using Groups to Manage Application Express Users
• Monitoring Activity within a Workspace
  • Viewing Developer Activity and Application Change Information
  • Viewing Application Changes by Developer
  • Viewing Application Changes by Day
  • Viewing Active Sessions

9 Managing User Interface Defaults

• Viewing Tables or Views Utilizing User Interface Defaults
  • Creating to User Interface Defaults
  • Viewing the UI Defaults Report in Object Browser
• Editing Column Attributes
  • About the Column Definition
  • About List of Values
  • About the Database Column Definition Report
• Comparing User Interface Defaults Across Applications
• About Exporting and Importing User Interface Defaults

10 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

11 Managing Application Security

• About Cross-Site Scripting Protection
  • Protecting HTML Regions and Other Static Areas
  • 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
  • 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
  • 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
  • Attaching an Authorization Scheme to an Application, Page, or Components
  • Viewing Authorization Reports

12 Deploying an Application

• About the Oracle Application Express Application Development Life Cycle
  • System Development Life Cycle Methodologies to Consider
• Understanding the Packaging Process
  • Deployment Options to Consider
  • Deciding Whether to Copy a Workspace
  • Deciding Whether to Copy a Database
  • About the Application ID
  • Deciding to Install a New HTTP Server
• How to Move an Application to Another Development Instance
  • About Managing Database Objects
• How to Create a Packaged Application
  • How a Packaged Application Simplifies Deployment
  • Creating a Packaged Application
  • 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
  • Creating Build Options
  • Managing Build Options
  • Exporting Build Options or Build Option Status
  • Viewing the Build Option Utilization Report

13 Advanced Programming Techniques

• About DML Lockings
• Accessing Data with Database Links
• Sending Email from an Application
  • About Configuring Oracle Application Express to Send Email
  • Sending Email from an Application
• Using Collections
  • About the APEX_COLLECTION API
  • 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
  • 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
  • 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 on a Web Service
  • Invoking a Web Service as a Process
  • Editing a Web Service Process
  • Viewing a Web Service Reference History

14 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
  • Using Format Masks for Items
  • Translating Applications for Multibyte Languages
• Understanding the Translation Process
  • Step 1: Map the Target Language
  • Step 2: Seed and Export Text to a Translation File
  • Step 3: Translate the XLIFF File
  • Step 4: Upload and Apply a Translated XLIFF Document and Publish the Application
  • 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
  • Defining a Dynamic Translation
  • APEX_LANG.LANG API
• About Supported Globalization Codes

15 Oracle Application Express APIs

• APEX_UTIL
  • CHANGE_CURRENT_USER_PW Procedure
  • CACHE_GET_DATE_OF_PAGE_CACHE Procedure
  • CACHE_GET_DATE_OF_REGION_CACHE Procedure
  • CACHE_PURGE_BY_APPLICATION Procedure
  • CACHE_PURGE_BY_PAGE Procedure
  • CACHE_PURGE_STALE Procedure
  • CHANGE_PASSWORD_ON_FIRST_USE Function
  • CLEAR_APP_CACHE Procedure
  • CLEAR_PAGE_CACHE Procedure
  • CLEAR_USER_CACHE Procedure
  • COUNT_CLICK Procedure
  • COUNT_STALE_REGIONS Function
  • CREATE_USER Procedure
  • CREATE_USER_GROUP Procedure
  • CURRENT_USER_IN_GROUP Function
  • EDIT_USER Procedure
  • END_USER_ACCOUNT_DAYS_LEFT Function
  • EXPIRE_END_USER_ACCOUNT Procedure
  • EXPIRE_WORKSPACE_ACCOUNT Procedure
  • EXPORT_USERS Procedure
  • FETCH_APP_ITEM Function
  • FETCH_USER Procedure
  • FIND_SECURITY_GROUP_ID Function
  • FIND_WORKSPACE Function
  • GET_ACCOUNT_LOCKED_STATUS Function
  • GET_ATTRIBUTE Function
  • GET_AUTHENTICATION_RESULT Function
  • GET_CURRENT_USER_ID Function
  • GET_DEFAULT_SCHEMA Function
  • GET_EMAIL Function
  • GET_FILE Procedure
  • GET_FILE_ID Function
  • GET_FIRST_NAME Function
  • GET_GROUPS_USER_BELONGS_TO Function
  • GET_GROUP_ID Function
  • GET_GROUP_NAME Function
  • GET_LAST_NAME Function
  • GET_USERNAME Function
  • GET_NUMERIC_SESSION_STATE Function
  • GET_PREFERENCE Function
  • GET_SESSION_STATE Function
  • GET_USER_ID Function
  • GET_USER_ROLES Function
  • IS_LOGIN_PASSWORD_VALID Function
  • IS_USERNAME_UNIQUE Function
  • KEYVAL_NUM Function
  • KEYVAL_VC2 Function
  • LOCK_ACCOUNT Procedure
  • PASSWORD_FIRST_USE_OCCURRED Function
  • PREPARE_URL Function
  • PUBLIC_CHECK_AUTHORIZATION Function
  • PURGE_REGIONS_BY_APP Procedure
  • PURGE_REGIONS_BY_ID Procedure
  • PURGE_REGIONS_BY_NAME Procedure
  • PURGE_REGIONS_BY_PAGE Procedure
  • PURGE_STALE_REGIONS Procedure
  • REMOVE_PREFERENCE Procedure
  • REMOVE_SORT_PREFERENCES Procedure
  • REMOVE_USER Procedure
  • RESET_AUTHORIZATIONS Procedure
  • RESET_PW Procedure
  • SAVEKEY_NUM Function
  • SAVEKEY_VC2 Function
  • SET_ATTRIBUTE Procedure
  • SET_AUTHENTICATION_RESULT Procedure
  • SET_CUSTOM_AUTH_STATUS Procedure
  • SET_EMAIL Procedure
  • SET_FIRST_NAME Procedure
  • SET_LAST_NAME Procedure
  • SET_PREFERENCE Procedure
  • SET_SESSION_STATE Procedure
  • SET_USERNAME Procedure
  • STRING_TO_TABLE Function
  • TABLE_TO_STRING Function
  • UNEXPIRE_END_USER_ACCOUNT Procedure
  • UNEXPIRE_WORKSPACE_ACCOUNT Procedure
  • UNLOCK_ACCOUNT Procedure
  • URL_ENCODE Function
  • WORKSPACE_ACCOUNT_DAYS_LEFT Function
• APEX_MAIL
  • SEND Procedure
  • PUSH_QUEUE Procedure
• APEX_ITEM
  • CHECKBOX Function
  • DATE_POPUP Function
  • DISPLAY_AND_SAVE Function
  • HIDDEN Function
  • MD5_CHECKSUM Function
  • MD5_HIDDEN Function
  • MULTI_ROW_UPDATE Procedure
  • POPUP_FROM_LOV Function
  • POPUP_FROM_QUERY Function
  • POPUPKEY_FROM_LOV Function
  • POPUPKEY_FROM_QUERY Function
  • RADIOGROUP Function
  • SELECT_LIST Function
  • SELECT_LIST_FROM_LOV Function
  • SELECT_LIST_FROM_LOV_XL Function
  • SELECT_LIST_FROM_QUERY Function
  • SELECT_LIST_FROM_QUERY_XL Function
  • TEXTAREA Function
  • TEXT Function
  • TEXT_FROM_LOV Function
  • TEXT_FROM_LOV_QUERY Function
• APEX_APPLICATION
  • Referencing Arrays
  • Referencing Values Within an On Submit Process
  • Converting an Array to a Single Value
• APEX_CUSTOM_AUTH
  • APPLICATION_PAGE_ITEM_EXISTS Function
  • CURRENT_PAGE_IS_PUBLIC Function
  • DEFINE_USER_SESSION Procedure
  • GET_COOKIE_PROPS Procedure
  • GET_LDAP_PROPS Procedure
  • GET_NEXT_SESSION_ID Function
  • GET_SESSION_ID_FROM_COOKIE Function
  • GET_USERNAME Function
  • GET_SECURITY_GROUP_ID Function
  • GET_SESSION_ID Function
  • GET_USER Function
  • IS_SESSION_VALID Function
  • LOGIN Procedure
  • LOGOUT Procedure
  • POST_LOGIN Procedure
  • SESSION_ID_EXISTS Function
  • SET_USER Procedure
  • SET_SESSION_ID Procedure
  • SET_SESSION_ID_TO_NEXT_VALUE Procedure
• APEX_LDAP
  • AUTHENTICATE Function
  • IS_MEMBER Function
  • MEMBER_OF Function
  • MEMBER_OF2 Function
  • GET_USER_ATTRIBUTES Procedure
  • GET_ALL_USER_ATTRIBUTES Procedure

Part III Database Tools

16 Managing Database Objects with Object Browser

• About Object Browser
  • Accessing Object Browser
• Searching For and Browsing Database Objects
  • Searching For and Selecting Database Objects
  • Hiding the Object Selection Pane
  • Using the Find Tables Icon
• About Creating New Database Objects
• Managing Tables
  • Creating a Table
  • Browsing a Table
  • Editing a Table
  • Dropping a Table
• Managing Views
  • Creating a View
  • Browsing a View
  • Editing a View
  • Compiling a View
  • Dropping a View
• Managing Indexes
  • Creating an Index
  • Browsing an Index
  • Dropping an Index
• Managing Sequences
  • Creating a Sequence
  • Browsing a Sequence
  • Dropping a Sequence
• Managing Types
  • Creating a Type
  • Browsing a Type
  • Dropping a Type
• 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
  • Creating a Database Link
  • Browsing a Database Link
  • Dropping a Database Link
• Managing Materialized Views
  • Creating a Materialized View
  • Browsing a Materialized View
  • Dropping a Materialized View
• Managing Synonyms
  • Creating Synonyms
  • Viewing a Synonym
  • Dropping a Synonym

17 Building Queries with Query Builder

• About Query Builder
  • Accessing Query Builder
  • Understanding the Query Building Process
• Using the Object Selection Pane
  • Searching and Filtering Objects
  • Hiding the Object Selection Pane
• Selecting Objects
  • About Supported Column Types
  • Adding an Object to the Design Pane
  • Removing or Hiding Objects in the Design Pane
• Specifying Query Conditions
• Creating Relationships Between Objects
  • About Join Conditions
  • Joining Objects Manually
  • Joining Objects Automatically
• Working with Saved Queries
  • Saving a Query
  • Editing a Saved Query
  • Deleting a Saved Query
• Viewing Generated SQL
• Viewing Query Results

18 Using SQL Scripts

• What is SQL Scripts?
• Accessing SQL Scripts
  • About the SQL Scripts Page
• Creating a SQL Script
  • Creating a SQL Script in the Script Editor
  • Uploading a SQL Script
• Using the Script Editor
  • Editing an Existing Script
  • Searching and Replacing Text or Regular Expressions
  • Summary of Script Editor Controls
• Deleting a SQL Script
  • Deleting Scripts from the SQL Scripts Page
  • Deleting a Script in the Script Editor
• Copying a SQL Script
• Executing a SQL Script
  • Executing a SQL Script in the Script Editor
  • Executing a SQL Script from the SQL Scripts Page
  • About the Run Script Page
• Viewing SQL Script Results
  • Viewing Results from the SQL Scripts Page
  • About the Results Page
• Exporting and Importing SQL Scripts
  • Copying Scripts to an Export Script
  • Importing Scripts from an Export Script
• Viewing Script and Result Quotas

19 Using SQL Commands

• What is SQL Commands?
• Accessing SQL Commands
• About the SQL Commands Home Page
• Using the Command Editor
  • Running a SQL Command
  • About Transactions in SQL Commands
  • About Unsupported SQL*Plus Commands
  • About Command Termination
  • Using Bind Variables
• Saving a SQL Command
• Copying a Command
• Using Saved Commands
  • Accessing Saved Commands
  • About the Saved SQL Pane
• Using SQL Command History
  • Accessing a Command from Command History
  • About the History Pane
• Viewing Results
  • Accessing the Results Pane
  • About the Results Pane
• Using Explain Plan
  • Viewing an Explain Plan
  • About Explain Plan Pane

20 Using Application Express Utilities

• About Importing, Exporting, Loading, and Unloading Data
  • Choosing the Right Import/Export/Load/Unload Option
• Loading and Unloading Data from the Database
  • Accessing the Data Load/Unload Page
  • Loading Data
  • Unloading Data
  • Using Text Data Load Repository
• Generating DDL
• Viewing Object Reports
  • Table Reports
  • Security Reports
  • PL/SQL Reports
  • Exception Reports
  • All Object Reports
• Using the Recycle Bin to View and Restore Dropped Objects
  • Managing Objects in the Recycle Bin
  • Emptying the Recycle Bin Without Viewing the Objects
• Reviewing Application Express Views
• Comparing Schemas
• Monitoring the Database
  • Sessions
  • About System Statistics
  • About Top SQL
  • About Long Operations
• Viewing Database Details

21 Migrating Applications

• About Application Migration
• Preparation Checklist for Migrating Applications
• How to Migrate Your Applications
• Step 1: Export Microsoft Access Metadata
• Step 2: Migrate the Microsoft Access Database to Oracle
• Step 3: Create an Oracle Application Express Workspace
• Step 4: Create a Migration Project
  • About the Project Page
• Step 5: Review Your Retrieved Objects
  • Reviewing Retrieved Tables
  • Reviewing Retrieved Queries
  • Reviewing Retrieved Forms
  • Reviewing Retrieved Reports
  • Reviewing Database, Module, and Pages Information
• Step 6: Generate the Oracle Application Express Application
• Managing Your Migration Projects

Part IV Administration

22 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
  • Managing Session State
  • 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
  • Configuring Email Settings
  • Configuring Wallet Information
  • Configuring Report Printing
  • Configuring Workspace Size Options for Requests
  • Managing Login and System Messages
• Managing Schemas
  • Determining the Application Express Engine Schema
  • Understanding Oracle Default Schema Restrictions
• 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
  • Creating New User Accounts
  • Editing an Existing User Account
  • Deleting User Accounts
• Managing Existing Workspaces
  • Viewing Existing Workspaces
  • Viewing Workspace Details
  • Viewing Workspace Database Privileges
  • About 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

      A Available Conditions

B Privileges Granted to PUBLIC

• Packages
• Procedures
• Functions
• Tables
• Views

      Index