Index

A

Autonomous database
- loading data 5.1.7

C

Column Statistics 3.3.7
copy and paste CSV data, loading 5.1.5.2
create
- generate 5.3
Create Lookup Table 3.3.4

D

data
- exporting from database 5.1.6
- loading 5.1, 5.1.1, 5.1.2
- loading into database 5.1.5
- unloading 5.1, 5.1.1, 5.1.2, 5.1.6
database
- loading data into 5.1, 5.1.1, 5.1.2
- monitoring 5.12
- unloading data from 5.1, 5.1.1, 5.1.2
database definition language, generating DDL statements 5.5
database link
- browsing 3.12.2
- creating 3.12.1
- testing 3.12.3
Database Monitor
- I/O 5.12.2.5
- Locks 5.12.2.3
- Long Operations 5.12.7
- Open Cursors 5.12.2.7
- required 5.12.1
- Sessions 5.12.2.1, 5.12.2.2
- SQL 5.12.2.6
- Top SQL 5.12.5
- Waits 5.12.2.4
database objects
- purging 5.9
- restoring 5.9
database security
- Column Privileges report 5.10.4
- Role Privileges report 5.10.4
- System Privileges report 5.10.4
data dictionary, browsing 5.10.5
Data Workshop 5.1, 5.1.1, 5.1.2
- load data 5.1.1
- loading data from Cloud 5.1.7
- unload data 5.1.1
DDL
- about 5.5
- generating 5.5

E

Explain Plan
- about 4.8
- using 4.8
exporting data
- summary of available methods 5.1.3
Export XML Wizard 5.1.6.2

F

function
- browsing 3.10.2
- compiling 3.10.5
- creating 3.10.1
- downloading 3.10.6
- dropping 3.10.7
- editing 3.10.4

I

I/O report 5.12.2.5
importing data, summary of methods 5.1.3
index
- browsing 3.5.2
- creating 3.5.1
- disabling 3.5.2, 3.5.3
- dropping 3.5.4
- rebuilding 3.5.2, 3.5.3
- statistics about 3.5.3

J

JSON file
- loading 5.1.5.4

L

Locks report 5.12.2.3

M

materialized view
- browsing 3.13.2
- creating 3.13.1
- dependent objects 3.13.3
- dropping 3.13.4
- list of grants 3.13.3
- report of data 3.13.3
- sort by column 3.13.3
- viewing object details 3.13.3

O

Object Browser
- accessing 3.1
- creating objects 3.2.6
- filtering objects 3.2.2
- Hide Objects control 3.2.5
- hiding Object Selection pane 3.2.5
- managing database links 3.12
- managing functions 3.10
- managing indexes 3.5
- managing materialized views 3.13
- managing packages 3.8
- managing procedures 3.9
- managing sequences 3.6
- managing tables 3.3
- managing triggers 3.11
- managing types 3.7
- managing views 3.4
- Statistics 3.3.7
- synonyms 3.14
Object Reports
- All Objects 5.10.5
- All Objects report 5.10.5
- Column Privileges report 5.10.4
- Data Dictionary 5.10.5
- Exception Reports 5.10.3
- Invalid Objects 5.10.5
- Object Calendar 5.10.5
- Object Counts by Type 5.10.5
- PL/SQL Source Code report 5.10.2.3
- Role Privileges report 5.10.4
- System Privileges report 5.10.4
objects
- purging 5.9
- restoring 5.9
Open Cursors report 5.12.2.7
Oracle Cloud
- granting privileges to workspace schema 5.1.7.1
- UI differences 5.1.7.2
Oracle Optimizer, Explain Plan 4.8
Oracle REST Data Services
- enabling 7.2
- registering 7.4.2
ORDS RESTful services
- about dashboard 7.4.3
- creating 7.6.3
- deleting 7.6.5
- editing 7.6.4
- exporting 7.6.11
- importing 7.6.12
- managing privileges 7.6.6
- managing resource templates 7.7

P

package
- Auto Complete 3.8.3
- compiling 3.8.5
- creating 3.8.1
- downloading 3.8.3, 3.8.6
- dropping 3.8.7, 3.8.8
- editing 3.8.3, 3.8.4
- Find 3.8.3
- grants for 3.8.3
- object dependencies 3.8.3
- package body 3.8.3
- related errors 3.8.3
- Replace 3.8.3
- viewing 3.8.2
procedure
- browsing 3.9.2
- compiling 3.9.5
- creating 3.9.1
- downloading 3.9.6
- dropping 3.9.7
- editing 3.9.4
- editing manually 3.9.4.1
- finding 3.9.3
- replacing 3.9.3

Q

Query Builder
- about 5.2.1
- accessing 5.2.2
- creating joins automatically 5.2.7.3
- creating joins manually 5.2.7.2
- filtering objects 5.2.4.1
- hiding objects in Design Pane 5.2.5.4
- Object Selection pane 5.2.4.2
- removing objects in Design Pane 5.2.5.4
- resizing panes 5.2.5.3
- Saved SQL tab 5.2.8.2
- searching for objects 5.2.4.1
- supported column types 5.2.5.1
- Table Actions 5.2.7.3
- View Actions 5.2.7.3
Quick SQL 5.3
- getting started 5.3.1
- loading samples 5.3.6
- saving as model 5.3.5
- saving as script 5.3.5
Quick SQL:
- load samples 5.3.6.2
- saving a model 5.3.5.1
- saving a script 5.3.5.3
Quick SQL model: 5.3.5.1
- accessing 5.3.5.2
- delete 5.3.5.2
- edit 5.3.5.2
Quick SQL samples:
- load 5.3.6.2

R

Recycle Bin
- purging 5.9
- searching 5.9
- using 5.9
- viewing objects 5.9
reports
- database objects 5.10.5
- Data Dictionary 5.10.5
- exception reports 5.10.3
- PL/SQL Source Code 5.10.2.3
Representational State Transfer (REST) 7.1.2
resource handler
- adding 7.8.1
- deleting 7.8.3
- editing 7.8.2
resource template
- adding 7.7.1
- deleting 7.7.3
- editing 7.7.2
- managing 7.7
REST 7.1.2
RESTful services
- about oracle.example.hr 7.5.1
- accessing 7.4.1
- creating 7.6.1, 7.6.2
- example 7.5.1
- managing 7.6
- managing resource handlers 7.8
- requirements 7.1.1
- Schema ORDS Enabled 7.6.2
- Schema ORDS not Enabled 7.6.1
- using 7
RESTful Services
- example 7.1.6
- resource handler 7.1.5
- resource module 7.1.3
- REST 7.1.2
- terminology 7.1.7
results 6.4

S

sample data set
- loading 5.1.5.2
schema
- selecting 2.2
scripts
- creating in editor 6.5.1
- deleting from editor 6.8.2
- deleting from SQL Scripts page 6.8.1
- executing 6.10
- executing from SQL Scripts page 6.10.2
- executing in editor 6.10.1
- export 6.4
- exporting 6.12
- results 6.4
- SQL Script editor 6.6
- uploading to another account 6.4
- uploading to SQL Scripts 6.5.2
- viewing repository quotas 6.13
Security reports
- Column Privileges report 5.10.4
- Object Grants 5.10.4
- Role Privileges 5.10.4
- System Privileges 5.10.4
sequence
- altering 3.6.3
- browsing 3.6.2
- creating 3.6.1
- dependent objects 3.6.3
- dropping 3.6.4
- grants associated with 3.6.3
- sequence 3.6.5
session, killing 5.12.2.2
Session report 5.12.2.2
SQL:
- shorthand syntax 5.3
SQL*Plus commands, unsupported 4.4.3
SQL*Plus command support 4.4.3
SQL Commands
- home page 4.3
- running Explain Plan 4.8
- transaction support 4.4.2
SQL report 5.12.2.6
SQL Scripts
- accessing 6.2
- creating script in editor 6.5.1
- deleting script from editor 6.8.2
- deleting script from SQL Scripts home page 6.8.1
- executing script from SQL Scripts page 6.10.2
- executing script in editor 6.10.1
- exporting scripts 6.12
- importing 6.12
- importing scripts 6.12
- script editor 6.6
- SQL Scripts page 6.3
- uploading script 6.5.2
- viewing quotas 6.13
SQL Scripts page
- accessing Manage Script Results 6.4
- Show Quotas 6.4
- Task list 6.4
SQL Scripts page Task list
- export scripts 6.4
- uploading scripts 6.4
SQL Workshop
- about 2
- Create App button 6.7
- icons 2.1
- overview 2
- selecting a scheme 2.2
SQL Workshop home page
- icons 2.1
- selecting a schema 2.2
Swagger
- document 7.6.13
synonym
- creating 3.14.1
- dropping 3.14.3
- viewing 3.14.2

T

tables
- add column 3.3.4
- browsing 3.3.2
- constraints 3.3.3
- copy 3.3.4
- creating 3.3.1
- drop column 3.3.4
- dropping 3.3.5
- editing 3.3.4
- exporting user interface defaults 5.6.6
- exports data to spreadsheet 3.3.3
- grants on 3.3.3
- indexes associated 3.3.3
- insert row 3.3.3
- modify column 3.3.4
- remove all rows 3.3.4
- rename 3.3.4
- rename column 3.3.4
- report of number of rows 3.3.3
- sort by column 3.3.3
- statistics about 3.3.3
- user interface defaults 3.3.3
- viewing data 3.3.3
Table Statistics 3.3.7
transaction support 4.4.2
trigger
- browsing 3.11.2
- compiling 3.11.5
- creating 3.11.1
- disabling, enabling 3.11.8
- downloading 3.11.6
- dropping 3.11.7
- editing 3.11.4
type
- browsing 3.7.2
- creating 3.7.1
- dropping 3.7.4
- grants associated with 3.7.3
- list of synonyms 3.7.3

U

Unload data Wizard 5.1.6.1
Unload to XML Wizard 5.1.6.2
utilities
- about 5
- comparing schemas 5
- generating DDL 5
- loading data 5
- monitoring the database 5
- restoring dropped objects 5
- unloading data 5
- viewing database details 5
- viewing object reports 5
Utilities, Data Dictionary 5.10.5

V

view
- browsing 3.4.2
- compiling 3.4.7
- creating 3.4.1
- dropping 3.4.8
- editing 3.4.4
- grants associated with 3.4.3
- objects referenced by 3.4.3
- report of data 3.4.3
- user interface defaults 3.4.3

W

Waits report 5.12.2.4
wizards
- exporting contents of table 5.1.6.1
- exporting text file 5.1.6.1
- exporting XML 5.1.6.2

X

XLSX file
- loading 5.1.5.5
XML document
- exporting to 5.1.6.2
- loading 5.1.5.3