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
- Accessing Object Browser
- Object Browser
- Searching for and Browsing Database Objects
- Searching For and Selecting Database Objects
- Hiding the Object Selection Pane
- Creating Database Objects
- Managing Tables
- Managing Views
- Managing Indexes
- Managing Sequences
- Managing Types
- Managing Packages
- Managing Procedures
- Managing Functions
- Managing Triggers
- Managing Database Links
- Managing Materialized Views
- Managing Synonyms
- 3 Using SQL Commands
-
4
Using Oracle Application Express Utilities
- Using Data Workshop
- Using Query Builder
- Using Quick SQL
- Using Sample Datasets
- Generating DDL
- Managing User Interface Defaults
- Comparing Schemas
- Managing Methods on Tables
- Using the Recycle Bin
- Viewing Object Reports
- Viewing Database Details
- Monitoring the Database
- 5 Using SQL Scripts
-
6
Enabling Data Exchange with RESTful Services
- What Is REST?
- About Oracle RESTful Services
- RESTful Service Requirements
- How to Access RESTful Services
-
How to Create the ORDS Based RESTful Services Module Example
- About the Example RESTful Service Module (oracle.example.hr)
- Returning the Result Set Based on a PL/SQL Block (empsecformat/:empname)
- Returning the Result Set in JSON Format with Pagination Set (employees/)
- Retrieving Data Based on a Parameter (employees/:id)
- Returning the Result Set in CSV Format (empinfo/)
- Returning the Result Set as a Feed (employeesfeed/)
-
Managing RESTful Service Modules
- Installing a Sample RESTful Service Module with Schema ORDS not Enabled
- Installing a Sample RESTful Service Module with Schema ORDS Enabled
- Creating an ORDS RESTful Service Module
- Editing an ORDS RESTful Service Module
- Deleting an ORDS RESTful Service Module
- Managing an ORDS RESTful Service Privileges
- Assigning Privileges to an ORDS RESTful Service Modules
- Creating an ORDS RESTful Service Privilege
- Editing an RESTful Service Privilege
- Deleting an ORDS RESTful Service Privilege
- Exporting an ORDS RESTful Service Module
- Importing an ORDS RESTful Service Module
- Generating a Swagger Document
- Managing Resource Templates
- Managing Resource Handlers
- Index