Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release
- 1 Getting Started with SQL Workshop
-
2
Managing Database Objects with Object Browser
- 2.1 Accessing Object Browser
- 2.2 Object Browser
- 2.3 Searching for and Browsing Database Objects
- 2.4 Searching For and Selecting Database Objects
- 2.5 Hiding the Object Selection Pane
- 2.6 Creating Database Objects
- 2.7 Managing Tables
- 2.8 Managing Views
- 2.9 Managing Indexes
- 2.10 Managing Sequences
- 2.11 Managing Types
- 2.12 Managing Packages
- 2.13 Managing Procedures
- 2.14 Managing Functions
- 2.15 Managing Triggers
- 2.16 Managing Database Links
- 2.17 Managing Materialized Views
- 2.18 Managing Synonyms
- 3 Using SQL Commands
-
4
Using Oracle Application Express Utilities
- 4.1 Using Data Workshop
-
4.2
Using Query Builder
- 4.2.1 Query Builder Home Page
- 4.2.2 Accessing Query Builder
- 4.2.3 Understanding the Query Building Process
- 4.2.4 Using the Object Selection Pane
- 4.2.5 Using the Design Pane
- 4.2.6 Specifying Query Conditions
- 4.2.7 Creating Relationships Between Objects
- 4.2.8 Working with Saved Queries
- 4.2.9 Viewing Generated SQL
- 4.2.10 Viewing Query Results
-
4.3
Using Quick SQL
- 4.3.1 Getting Started with Quick SQL
- 4.3.2 Using Quick SQL Help
- 4.3.3 Generating Quick SQL with SQL Shorthand Syntax
- 4.3.4 Saving Scripts
- 4.3.5 Creating an Application from a Generated SQL Script
- 4.3.6 Using Quick SQL Samples
- 4.3.7 Configuring Settings
- 4.3.8 About Database Terminology
- 4.3.9 Recommendations When Using Quick SQL
- 4.3.10 About Supported Data Types
- 4.4 Using Sample Datasets
- 4.5 Generating DDL
- 4.6 Managing User Interface Defaults
- 4.7 Comparing Schemas
- 4.8 Managing Methods on Tables
- 4.9 Using the Recycle Bin
- 4.10 Viewing Object Reports
- 4.11 Viewing Database Details
- 4.12 Monitoring the Database
-
5
Using SQL Scripts
- 5.1 About SQL Scripts
- 5.2 Accessing SQL Scripts
- 5.3 About the SQL Scripts Page
- 5.4 About the Tasks List
- 5.5 Creating a SQL Script
- 5.6 Using the Script Editor
- 5.7 Deleting a SQL Script
- 5.8 Copying a SQL Script
- 5.9 Executing a SQL Script
- 5.10 Viewing SQL Script Results
- 5.11 Exporting and Importing SQL Scripts
- 5.12 Viewing Script and Result Quotas
-
6
Enabling Data Exchange with RESTful Services
- 6.1 What Is REST?
- 6.2 About Oracle RESTful Services
- 6.3 RESTful Service Requirements
- 6.4 How to Enable REST Objects from the Object Browser
- 6.5 How to Access RESTful Services
-
6.6
How to Create the ORDS Based RESTful Services Module Example
- 6.6.1 About the Example RESTful Service Module (oracle.example.hr)
- 6.6.2 Returning the Result Set Based on a PL/SQL Block (empsecformat/:empname)
- 6.6.3 Returning the Result Set in JSON Format with Pagination Set (employees/)
- 6.6.4 Retrieving Data Based on a Parameter (employees/:id)
- 6.6.5 Returning the Result Set in CSV Format (empinfo/)
- 6.6.6 Returning the Result Set as a Feed (employeesfeed/)
-
6.7
Managing RESTful Service Modules
- 6.7.1 Installing a Sample RESTful Service Module with Schema ORDS not Enabled
- 6.7.2 Installing a Sample RESTful Service Module with Schema ORDS Enabled
- 6.7.3 Creating an ORDS RESTful Service Module
- 6.7.4 Editing an ORDS RESTful Service Module
- 6.7.5 Deleting an ORDS RESTful Service Module
- 6.7.6 Managing an ORDS RESTful Service Privileges
- 6.7.7 Assigning Privileges to an ORDS RESTful Service Modules
- 6.7.8 Creating an ORDS RESTful Service Privilege
- 6.7.9 Editing an RESTful Service Privilege
- 6.7.10 Deleting an ORDS RESTful Service Privilege
- 6.7.11 Exporting an ORDS RESTful Service Module
- 6.7.12 Importing an ORDS RESTful Service Module
- 6.7.13 Generating a Swagger Document
- 6.8 Managing Resource Templates
- 6.9 Managing Resource Handlers
- Index