Contents

Title and Copyright Information

Preface

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

1 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

2 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

3 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

4 Using Oracle 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

5 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

Index