Index

C  D  E  F  I  L  M  O  P  Q  R  S  T  U  V  W  X 

---

C

Create Lookup Table, 2.7.4

---

D

data

exporting from database, 5.1.6

loading, 5.1

loading into database, 5.1.5

unloading, 5.1, 5.1.6

data dictionary, browsing, 5.4.5

Data Workshop, 5.1

database

loading data into, 5.1

monitoring, 5.9

unloading data from, 5.1

database definition language, generating DDL statements, 5.2

database link

browsing, 2.16.2

creating, 2.16.1

testing, 2.16.3

Database Monitor

I/O, 5.9.1.5

Locks, 5.9.1.3

Long Operations, 5.9.6

Open Cursors, 5.9.1.7

Sessions, 5.9.1.1, 5.9.1.2

SQL, 5.9.1.6

Top SQL, 5.9.4

Waits, 5.9.1.4

database monitoring, system statistics, 5.9.2

database objects

purging, 5.10

restoring, 5.10

database security

Column Privileges report, 5.4.4

Role Privileges report, 5.4.4

System Privileges report, 5.4.4

DDL

about, 5.2

generating, 5.2

---

E

Explain Plan

about, 3.8

using, 3.8, 3.8

Export XML Wizard, 5.1.6.2

exporting data

summary of available methods, 5.1.3

---

F

function

browsing, 2.14.2

compiling, 2.14.5

creating, 2.14.1

downloading, 2.14.6

dropping, 2.14.7

editing, 2.14.4

---

I

importing data, summary of methods, 5.1.3

index

browsing, 2.9.2

creating, 2.9.1

disabling, 2.9.2, 2.9.3

dropping, 2.9.4

rebuilding, 2.9.2, 2.9.3

statistics about, 2.9.3

I/O report, 5.9.1.5

---

L

Load Data Wizard, 5.1.5.2

Load XML Wizard, 5.1.5.3

Locks report, 5.9.1.3

---

M

materialized view

browsing, 2.17.2

creating, 2.17.1

dependent objects, 2.17.3

dropping, 2.17.4

list of grants, 2.17.3

report of data, 2.17.3

sort by column, 2.17.3

viewing object details, 2.17.3

---

O

Object Browser

accessing, 2.1

creating objects, 2.6

Hide Objects control, 2.5

hiding Object Selection pane, 2.5

managing database links, 2.16

managing functions, 2.14

managing indexes, 2.9

managing materialized views, 2.17

managing packages, 2.12

managing procedures, 2.13

managing sequences, 2.10

managing tables, 2.7

managing triggers, 2.15

managing types, 2.11

managing views, 2.8

searching for objects, 2.3

synonyms, 2.18

Object Reports

All Objects, 5.4.5

All Objects report, 5.4.5

Column Privileges report, 5.4.4

Data Dictionary, 5.4.5

Exception Reports, 5.4.3

Invalid Objects, 5.4.5

Object Calendar, 5.4.5

Object Counts by Type, 5.4.5

PL/SQL Source Code report, 5.4.2.3

Role Privileges report, 5.4.4

System Privileges report, 5.4.4

objects

purging, 5.10

restoring, 5.10

Open Cursors report, 5.9.1.7

Oracle Optimizer, Explain Plan, 3.8

---

P

package

Auto Complete, 2.12.3

compiling, 2.12.5

creating, 2.12.1

downloading, 2.12.3, 2.12.6

dropping, 2.12.7, 2.12.8

editing, 2.12.3, 2.12.4

Find, 2.12.3

grants for, 2.12.3

object dependencies, 2.12.3

package body, 2.12.3

related errors, 2.12.3

Replace, 2.12.3

viewing, 2.12.2

procedure

browsing, 2.13.2

compiling, 2.13.5

creating, 2.13.1

downloading, 2.13.6

dropping, 2.13.7

editing, 2.13.4

editing manually, 2.13.4.1

finding, 2.13.3

replacing, 2.13.3

---

Q

Query Builder

about, 5.6.1

accessing, 5.6.2

creating joins automatically, 5.6.7.3

creating joins manually, 5.6.7.2

filtering objects, 5.6.4.1

hiding objects in Design Pane, 5.6.5.4

Object Selection pane, 5.6.4.2

removing objects in Design Pane, 5.6.5.4

resizing panes, 5.6.5.3

Saved SQL tab, 5.6.8.2

searching for objects, 5.6.4.1

supported column types, 5.6.5.1

Table Actions, 5.6.7.3

View Actions, 5.6.7.3

---

R

Recycle Bin

purging, 5.10

searching, 5.10

using, 5.10

viewing objects, 5.10

reports

Data Dictionary, 5.4.5

database objects, 5.4.5

exception reports, 5.4.3

PL/SQL Source Code, 5.4.2.3

Representational State Transfer (REST), 6.1

resource handler

adding, 6.8.1

deleting, 6.8.3

editing, 6.8.2

resource template

adding, 6.7.1

deleting, 6.7.3

editing, 6.7.2

managing, 6.7

RESTful services

about, 6.2

about oracle.example.hr, 6.5.1

accessing, 6.4

creating, 6.6.1

deleting, 6.6.3

editing, 6.6.2

example, 6.5.1

exporting, 6.6.9

importing, 6.6.10

managing, 6.6

managing privileges, 6.6.4

managing resource handlers, 6.8

managing resource templates, 6.7

requirements, 6.3

using, 6

results, 4.4

---

S

schema

selecting, 1.2

scripts

creating in editor, 4.5.1

deleting from editor, 4.7.2

deleting from SQL Scripts page, 4.7.1

executing, 4.9

executing from SQL Scripts page, 4.9.2

executing in editor, 4.9.1

export, 4.4

exporting, 4.11

importing, 4.11

results, 4.4

SQL Script editor, 4.6

uploading to another account, 4.4

uploading to SQL Scripts, 4.5.2

viewing repository quotas, 4.12

Security reports

Column Privileges report, 5.4.4

Object Grants, 5.4.4

Role Privileges, 5.4.4

System Privileges, 5.4.4

sequence

altering, 2.10.3

browsing, 2.10.2

creating, 2.10.1

dependent objects, 2.10.3

dropping, 2.10.4

grants associated with, 2.10.3

Session report, 5.9.1.2

session, killing, 5.9.1.2

SQL Commands

home page, 3.3

running Explain Plan, 3.8

transaction support, 3.4.2

SQL report, 5.9.1.6

SQL Scripts

accessing, 4.2

creating script in editor, 4.5.1

deleting script from editor, 4.7.2

deleting script from SQL Scripts home page, 4.7.1

executing script from SQL Scripts page, 4.9.2

executing script in editor, 4.9.1

exporting scripts, 4.11

importing scripts, 4.11

script editor, 4.6

SQL Scripts page, 4.3

uploading script, 4.5.2

viewing quotas, 4.12

SQL Scripts page

accessing Manage Script Results, 4.4

Show Quotas, 4.4

Task list, 4.4

SQL Scripts page Task list

export scripts, 4.4

uploading scripts, 4.4

SQL Workshop

about, 1

icons, 1.1

overview, 1

selecting a scheme, 1.2

SQL Workshop home page

icons, 1.1

selecting a schema, 1.2

SQL*Plus command support, 3.4.5

SQL*Plus commands, unsupported, 3.4.5

synonym

creating, 2.18.1

dropping, 2.18.3

viewing, 2.18.2

---

T

tab-delimited file

loading, 5.1.5.2

tables

add column, 2.7.4

browsing, 2.7.2

constraints, 2.7.3

copy, 2.7.4

creating, 2.7.1

drop column, 2.7.4

dropping, 2.7.5

editing, 2.7.4

exporting user interface defaults, 5.7.6

exports data to spreadsheet, 2.7.3

grants on, 2.7.3

indexes associated, 2.7.3

insert row, 2.7.3

modify column, 2.7.4

remove all rows, 2.7.4

rename, 2.7.4

rename column, 2.7.4

report of number of rows, 2.7.3

sort by column, 2.7.3

statistics about, 2.7.3

user interface defaults, 2.7.3

viewing data, 2.7.3

text file, loading, 5.1.5.2

transaction support, 3.4.2

trigger

browsing, 2.15.2

compiling, 2.15.5

creating, 2.15.1

downloading, 2.15.6

dropping, 2.15.7

editing, 2.15.4

type

browsing, 2.11.2

creating, 2.11.1

dropping, 2.11.4

grants associated with, 2.11.3

list of synonyms, 2.11.3

---

U

Unload to Text 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.4.5

---

V

view

browsing, 2.8.2

compiling, 2.8.7

creating, 2.8.1

dropping, 2.8.8

editing, 2.8.4

grants associated with, 2.8.3

objects referenced by, 2.8.3

report of data, 2.8.3

user interface defaults, 2.8.3

---

W

Waits report, 5.9.1.4

wizards

copying and pasting tab-delimited data, 5.1.5.2

exporting contents of table, 5.1.6.1

exporting text file, 5.1.6.1

exporting XML, 5.1.6.2

importing text, 5.1.5.2

importing XML, 5.1.5.3

---

X

XML document

exporting to, 5.1.6.2

loading, 5.1.5.3