Contents

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
  • New Features
  • Other Changes

1 Managing Database Objects with Object Browser

• Accessing Object Browser
• About Object Browser
• Searching for and Browsing Database Objects
  • Searching For and Selecting Database Objects
  • Hiding the Object Selection Pane
• About Creating 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

2 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
  • Using the Find Tables Icon
• Saving an SQL Command
• Copying a Command
• Viewing Results
  • Accessing the Results Pane
  • About the Results Pane
• Using Explain Plan
  • Viewing an Explain Plan
  • About Explain Plan Pane
• 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

3 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
• 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

4 Using Oracle Application Express Utilities

• Building SQL Queries with Query Builder
  • About Query Builder
  • Using the Object Selection Pane
  • Selecting Objects
  • Specifying Query Conditions
  • Creating Relationships Between Objects
  • Working with Saved Queries
  • Viewing Generated SQL
  • Viewing Query Results
• Using the Data Workshop to Manage Data
  • About Importing, Exporting, Loading, and Unloading Data
  • Accessing the Data Load/Unload Page
  • Loading Data
  • Unloading Data
  • Using Repository
• Generating DDL
• Managing Methods on Tables
• Managing User Interface Defaults
  • Creating User Interface Defaults for a Table
  • Modifying Table User Interface Defaults
  • Creating User Interface Attributes
  • Modifying User Interface Attributes
  • About Exporting and Importing User Interface Defaults
• Viewing Database Details
• Comparing Schemas
• Viewing Object Reports
  • Table Reports
  • Security Reports
  • PL/SQL Reports
  • Exception Reports
  • All Object Reports
• Monitoring the Database
  • Sessions
  • About System Statistics
  • About Top SQL
  • About Long Operations
• Using the Recycle Bin to View and Restore Dropped Objects
  • Managing Objects in the Recycle Bin
  • Emptying the Recycle Bin Without Viewing the Objects

5 Using RESTful Services

• What Is REST?
• About RESTful Services
• RESTful Service Requirements
• Accessing RESTful Services
• About the Example RESTful Service Module (oracle.example.hr)
  • Returning the Result Set in CSV Format (empinfo/)
  • Retrieving Data Based on a Parameter (employees/{id})
  • Returning the Result Set in JSON Format with Pagination Set (employees/)
  • Returning the Result Set as a Feed (employeesfeed/)
  • Returning the Result Set Based on a PL/SQL Block (empsecformat/{empname})
• Managing RESTful Service Modules
  • Creating a RESTful Service Module
  • Editing a RESTful Service Module
  • Deleting a RESTful Service Module
  • Managing RESTful Service Privileges
  • Exporting a RESTful Service Module
  • Importing a RESTful Service Module
• Managing Resource Templates
  • Adding a Resource Template
  • Editing a Resource Template
  • Deleting a Resource Template
• Managing Resource Handlers
  • Adding a Resource Handler
  • Editing a Resource Handler
  • Deleting a Resource Handler

Index