Table of Contents
- Title and Copyright Information
- Preface
- 1 Changes in Release 24.1 for Oracle APEX SQL Workshop Guide
- 2 Getting Started with SQL Workshop
-
3
Managing Database Objects with Object Browser
- 3.1 Accessing Object Browser
- 3.2 Understanding Object Browser
- 3.3 Managing Tables
- 3.4 Managing Views
- 3.5 Managing Indexes
- 3.6 Managing Sequences
- 3.7 Managing Types
- 3.8 Managing Packages
- 3.9 Managing Procedures
- 3.10 Managing Functions
- 3.11 Managing Triggers
- 3.12 Managing Database Links
- 3.13 Managing Materialized Views
- 3.14 Managing Synonyms
- 3.15 Managing SODA Collections
- 4 Using SQL Commands
-
5
Using SQL Workshop Utilities
-
5.1
Using Data Workshop
- 5.1.1 About the Load Data and Unload Data Wizards
- 5.1.2 About Importing, Exporting, Loading, and Unloading Data
- 5.1.3 Import, Export, Load, and Unload Options
- 5.1.4 Accessing the Load Data and Unload Data Wizards
- 5.1.5 Loading Data
- 5.1.6 Unloading Data
-
5.1.7
Loading Data From the Oracle Cloud
(Autonomous Database Only)
- 5.1.7.1 Granting Privileges to the Workspace Schema
- 5.1.7.2 User Interface Differences for Oracle Cloud Users
- 5.1.7.3 About Object Store References
- 5.1.7.4 Creating an Object Store Reference
- 5.1.7.5 Creating an External Table from Cloud
- 5.1.7.6 Loading Avro or Parquet Files into Object Browser from Cloud
- 5.1.7.7 Loading Other Files into Object Browser from Cloud
- 5.2 Using Data Generator
-
5.3
Using Query Builder
- 5.3.1 Query Builder Home Page
- 5.3.2 Accessing Query Builder
- 5.3.3 Understanding the Query Building Process
- 5.3.4 Using the Object Selection Pane
- 5.3.5 Using the Design Pane
- 5.3.6 Specifying Query Conditions
- 5.3.7 Creating Relationships Between Objects
- 5.3.8 Working with Saved Queries
- 5.3.9 Viewing Generated SQL
- 5.3.10 Viewing Query Results
-
5.4
Using Quick SQL
- 5.4.1 Getting Started with Quick SQL
- 5.4.2 Accessing Quick SQL
- 5.4.3 About the Quick SQL Page
- 5.4.4 Accessing Quick SQL Help
- 5.4.5 Loading Quick SQL Sample Models
- 5.4.6 Generating SQL with SQL Shorthand Syntax
- 5.4.7 Managing Quick SQL Models and Scripts
- 5.4.8 Creating an Application from a Generated SQL Script
- 5.4.9 Configuring Quick SQL Settings
- 5.4.10 Recommendations When Using Quick SQL
- 5.4.11 Database Terminology Used in Quick SQL
- 5.4.12 About Supported Data Types
- 5.5 Using Sample Datasets
- 5.6 Generating DDL
- 5.7 Managing User Interface Defaults (UI Defaults)
- 5.8 Comparing Schemas
- 5.9 Managing Methods on Tables
- 5.10 Using the Recycle Bin
- 5.11 Viewing Object Reports
- 5.12 Viewing Database Details
- 5.13 Monitoring the Database
-
5.1
Using Data Workshop
-
6
Using SQL Scripts
- 6.1 About SQL Scripts
- 6.2 Accessing SQL Scripts
- 6.3 About the SQL Scripts Page
- 6.4 About the Tasks List
- 6.5 Creating a SQL Script
- 6.6 Using the Script Editor
- 6.7 Creating an Application from a Script
- 6.8 Deleting a SQL Script
- 6.9 Copying a SQL Script
- 6.10 Executing a SQL Script
- 6.11 Viewing SQL Script Results
- 6.12 Exporting and Importing SQL Scripts
- 6.13 Viewing Script and Result Quotas
-
7
Enabling Data Exchange with RESTful
Services
- 7.1 About Oracle RESTful Services in Oracle APEX
- 7.2 Enabling REST Objects
- 7.3 Enabling Authorization for REST-enabled Objects
- 7.4 How to Access RESTful Services
-
7.5
How to Create the ORDS Based RESTful Services Module Example
- 7.5.1 About the Example RESTful Service Module (oracle.example.hr)
- 7.5.2 Returning the Result Set Based on a PL/SQL Block (empsecformat/:empname)
- 7.5.3 Returning the Result Set in JSON Format with Pagination Set (employees/)
- 7.5.4 Retrieving Data Based on a Parameter (employees/:id)
- 7.5.5 Returning the Result Set in CSV Format (empinfo/)
- 7.5.6 Returning the Result Set as a Feed (employeesfeed/)
-
7.6
Managing RESTful Service Modules
- 7.6.1 Installing a Sample RESTful Service Module with Schema ORDS not Enabled
- 7.6.2 Installing a Sample RESTful Service Module with Schema ORDS Enabled
- 7.6.3 Creating an ORDS RESTful Service Module
- 7.6.4 Editing an ORDS RESTful Service Module
- 7.6.5 Deleting an ORDS RESTful Service Module
- 7.6.6 Managing an ORDS RESTful Service Privileges
- 7.6.7 Assigning Privileges to an ORDS RESTful Service Modules
- 7.6.8 Creating an ORDS RESTful Service Privilege
- 7.6.9 Editing an RESTful Service Privilege
- 7.6.10 Deleting an ORDS RESTful Service Privilege
- 7.6.11 Exporting an ORDS RESTful Service Module
- 7.6.12 Importing an ORDS RESTful Service Module
- 7.6.13 Generating a Swagger Document
- 7.7 Managing Resource Templates
- 7.8 Managing Resource Handlers
- 7.9 Accessing SQL Developer Web Directly from APEX
- Index