1/11

Contents

List of Tables

Title and Copyright Information

Preface

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

Changes in This Release

• Changes in Oracle Application Express Release 4.2

1 Managing Database Objects with Object Browser

• 1.1 Accessing Object Browser
• 1.2 About Object Browser
• 1.3 Searching for and Browsing Database Objects
  • 1.3.1 Searching For and Selecting Database Objects
  • 1.3.2 Hiding the Object Selection Pane
• 1.4 About Creating Database Objects
• 1.5 Managing Tables
  • 1.5.1 Creating a Table
  • 1.5.2 Browsing a Table
    • 1.5.2.1 Summary of Available Views
  • 1.5.3 Editing a Table
  • 1.5.4 Dropping a Table
• 1.6 Managing Views
  • 1.6.1 Creating a View
  • 1.6.2 Browsing a View
    • 1.6.2.1 Summary of Available Views
  • 1.6.3 Editing a View
    • 1.6.3.1 Editing a View Manually
    • 1.6.3.2 Using Find and Replace
    • 1.6.3.3 Downloading a View
  • 1.6.4 Compiling a View
  • 1.6.5 Dropping a View
• 1.7 Managing Indexes
  • 1.7.1 Creating an Index
  • 1.7.2 Browsing an Index
    • 1.7.2.1 Summary of Available Views
  • 1.7.3 Dropping an Index
• 1.8 Managing Sequences
  • 1.8.1 Creating a Sequence
  • 1.8.2 Browsing a Sequence
    • 1.8.2.1 Summary of Available Views
  • 1.8.3 Dropping a Sequence
• 1.9 Managing Types
  • 1.9.1 Creating a Type
  • 1.9.2 Browsing a Type
    • 1.9.2.1 Summary of Available Views
  • 1.9.3 Dropping a Type
• 1.10 Managing Packages
  • 1.10.1 Creating a Package
  • 1.10.2 Viewing a Package
    • 1.10.2.1 Summary of Available Views
  • 1.10.3 Editing a Package
    • 1.10.3.1 Editing a Package Manually
  • 1.10.4 Compiling a Package
  • 1.10.5 Downloading a Package
  • 1.10.6 Dropping a Package
• 1.11 Managing Procedures
  • 1.11.1 Creating a Procedure
  • 1.11.2 Browsing a Procedure
    • 1.11.2.1 Summary of Available Views
  • 1.11.3 Editing a Procedure
    • 1.11.3.1 Editing a Procedure Manually
  • 1.11.4 Compiling a Procedure
  • 1.11.5 Downloading a Procedure
  • 1.11.6 Dropping a Procedure
• 1.12 Managing Functions
  • 1.12.1 Creating a Function
  • 1.12.2 Browsing a Function
    • 1.12.2.1 Summary of Available Views
  • 1.12.3 Editing a Function
    • 1.12.3.1 Editing a Function Manually
  • 1.12.4 Compiling a Function
  • 1.12.5 Downloading a Function
  • 1.12.6 Dropping a Function
• 1.13 Managing Triggers
  • 1.13.1 Creating Triggers
  • 1.13.2 Browsing a Trigger
    • 1.13.2.1 Summary of Available Views
  • 1.13.3 Editing a Trigger
    • 1.13.3.1 Editing a Trigger Manually
  • 1.13.4 Compiling a Trigger
  • 1.13.5 Downloading a Trigger
  • 1.13.6 Dropping a Trigger
• 1.14 Managing Database Links
  • 1.14.1 Creating a Database Link
  • 1.14.2 Browsing a Database Link
    • 1.14.2.1 Summary of Available Views
  • 1.14.3 Dropping a Database Link
• 1.15 Managing Materialized Views
  • 1.15.1 Creating a Materialized View
  • 1.15.2 Browsing a Materialized View
    • 1.15.2.1 Summary of Available Views
  • 1.15.3 Dropping a Materialized View
• 1.16 Managing Synonyms
  • 1.16.1 Creating Synonyms
  • 1.16.2 Viewing a Synonym
  • 1.16.3 Dropping a Synonym

2 Using SQL Commands

• 2.1 What is SQL Commands?
• 2.2 Accessing SQL Commands
• 2.3 About the SQL Commands Home Page
• 2.4 Using the Command Editor
  • 2.4.1 Running a SQL Command
  • 2.4.2 About Transactions in SQL Commands
  • 2.4.3 About Unsupported SQL*Plus Commands
  • 2.4.4 About Command Termination
  • 2.4.5 Using Bind Variables
  • 2.4.6 Using the Find Tables Icon
• 2.5 Saving an SQL Command
• 2.6 Copying a Command
• 2.7 Viewing Results
  • 2.7.1 Accessing the Results Pane
  • 2.7.2 About the Results Pane
• 2.8 Using Explain Plan
  • 2.8.1 Viewing an Explain Plan
  • 2.8.2 About Explain Plan Pane
• 2.9 Using Saved Commands
  • 2.9.1 Accessing Saved Commands
  • 2.9.2 About the Saved SQL Pane
• 2.10 Using SQL Command History
  • 2.10.1 Accessing a Command from Command History
  • 2.10.2 About the History Pane

3 Using SQL Scripts

• 3.1 What is SQL Scripts?
• 3.2 Accessing SQL Scripts
  • 3.2.1 About the SQL Scripts Page
• 3.3 Creating a SQL Script
  • 3.3.1 Creating a SQL Script in the Script Editor
  • 3.3.2 Uploading a SQL Script
• 3.4 Using the Script Editor
  • 3.4.1 Editing an Existing Script
  • 3.4.2 Searching and Replacing Text or Regular Expressions
  • 3.4.3 Summary of Script Editor Controls
• 3.5 Deleting a SQL Script
  • 3.5.1 Deleting Scripts from the SQL Scripts Page
  • 3.5.2 Deleting a Script in the Script Editor
• 3.6 Copying a SQL Script
• 3.7 Executing a SQL Script
  • 3.7.1 Executing a SQL Script in the Script Editor
  • 3.7.2 Executing a SQL Script from the SQL Scripts Page
• 3.8 Viewing SQL Script Results
  • 3.8.1 Viewing Results from the SQL Scripts Page
  • 3.8.2 About the Results Page
• 3.9 Exporting and Importing SQL Scripts
  • 3.9.1 Copying Scripts to an Export Script
    • 3.9.1.1 About the Scripts Pane
    • 3.9.1.2 About the Scripts to Export Pane
  • 3.9.2 Importing Scripts from an Export Script
    • 3.9.2.1 About the Import Scripts Pane
• 3.10 Viewing Script and Result Quotas

4 Using Oracle Application Express Utilities

• 4.1 Building SQL Queries with Query Builder
  • 4.1.1 About Query Builder
    • 4.1.1.1 Accessing Query Builder
    • 4.1.1.2 Understanding the Query Building Process
  • 4.1.2 Using the Object Selection Pane
    • 4.1.2.1 Searching and Filtering Objects
    • 4.1.2.2 Hiding the Object Selection Pane
  • 4.1.3 Selecting Objects
    • 4.1.3.1 About Supported Column Types
    • 4.1.3.2 Adding an Object to the Design Pane
    • 4.1.3.3 Removing or Hiding Objects in the Design Pane
  • 4.1.4 Specifying Query Conditions
  • 4.1.5 Creating Relationships Between Objects
    • 4.1.5.1 About Join Conditions
    • 4.1.5.2 Joining Objects Manually
    • 4.1.5.3 Joining Objects Automatically
  • 4.1.6 Working with Saved Queries
    • 4.1.6.1 Saving a Query
    • 4.1.6.2 Editing a Saved Query
    • 4.1.6.3 Deleting a Saved Query
  • 4.1.7 Viewing Generated SQL
  • 4.1.8 Viewing Query Results
• 4.2 Using the Data Workshop to Manage Data
  • 4.2.1 About Importing, Exporting, Loading, and Unloading Data
    • 4.2.1.1 Choosing the Right Import/Export/Load/Unload Option
  • 4.2.2 Accessing the Data Load/Unload Page
  • 4.2.3 Loading Data
    • 4.2.3.1 Loading a Text File or Spreadsheet Data
    • 4.2.3.2 Loading an XML Document
  • 4.2.4 Unloading Data
    • 4.2.4.1 Unloading a Text File
    • 4.2.4.2 Unloading to an XML Document
  • 4.2.5 Using Repository
• 4.3 Generating DDL
• 4.4 Managing Methods on Tables
• 4.5 Managing User Interface Defaults
  • 4.5.1 Creating User Interface Defaults for a Table
  • 4.5.2 Modifying Table User Interface Defaults
  • 4.5.3 Creating User Interface Attributes
  • 4.5.4 Modifying User Interface Attributes
  • 4.5.5 About Exporting and Importing User Interface Defaults
• 4.6 Viewing Database Details
• 4.7 Comparing Schemas
• 4.8 Viewing Object Reports
  • 4.8.1 Table Reports
  • 4.8.2 Security Reports
  • 4.8.3 PL/SQL Reports
    • 4.8.3.1 Program Unit Arguments
    • 4.8.3.2 Unit Line Counts
    • 4.8.3.3 Search PL/SQL Source Code
  • 4.8.4 Exception Reports
  • 4.8.5 All Object Reports
• 4.9 Monitoring the Database
  • 4.9.1 Sessions
    • 4.9.1.1 Sessions Report
    • 4.9.1.2 Locks Report
    • 4.9.1.3 Waits Report
    • 4.9.1.4 I/O Report
    • 4.9.1.5 SQL Report
    • 4.9.1.6 Open Cursors
  • 4.9.2 About System Statistics
  • 4.9.3 About Top SQL
  • 4.9.4 About Long Operations
• 4.10 Using the Recycle Bin to View and Restore Dropped Objects
  • 4.10.1 Managing Objects in the Recycle Bin
  • 4.10.2 Emptying the Recycle Bin Without Viewing the Objects

5 Using RESTful Services

• 5.1 What Is REST?
• 5.2 About RESTful Services
• 5.3 RESTful Service Requirements
• 5.4 Accessing RESTful Services
• 5.5 About the Example RESTful Service Module (oracle.example.hr)
  • 5.5.1 Returning the Result Set in CSV Format (empinfo/)
  • 5.5.2 Retrieving Data Based on a Parameter (employees/{id})
  • 5.5.3 Returning the Result Set in JSON Format with Pagination Set (employees/)
  • 5.5.4 Returning the Result Set as a Feed (employeesfeed/)
  • 5.5.5 Returning the Result Set Based on a PL/SQL Block (empsecformat/{empname})
• 5.6 Managing RESTful Service Modules
  • 5.6.1 Creating a RESTful Service Module
  • 5.6.2 Editing a RESTful Service Module
  • 5.6.3 Deleting a RESTful Service Module
  • 5.6.4 Managing RESTful Service Privileges
    • 5.6.4.1 Assigning Privileges to RESTful Web Service Modules
    • 5.6.4.2 Creating a RESTful Service Privilege
    • 5.6.4.3 Editing a RESTful Service Privilege
    • 5.6.4.4 Deleting a RESTful Service Privilege
  • 5.6.5 Exporting a RESTful Service Module
  • 5.6.6 Importing a RESTful Service Module
• 5.7 Managing Resource Templates
  • 5.7.1 Adding a Resource Template
  • 5.7.2 Editing a Resource Template
  • 5.7.3 Deleting a Resource Template
• 5.8 Managing Resource Handlers
  • 5.8.1 Adding a Resource Handler
  • 5.8.2 Editing a Resource Handler
  • 5.8.3 Deleting a Resource Handler

Index