Index

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

C

command termination
in SQL Commands, 3.5.4
Create Lookup Table, 1.4.3

D

data
exporting from database, 4.2.3
loading, 4.2
loading into database, 4.2.2
unloading, 4.2, 4.2.3
data dictionary
browsing, 4.4.5
database
loading data into, 4.2
monitoring, 4.8
unloading data from, 4.2
database definition language
generating DDL statements, 4.3
database link
browsing, 1.13.2
creating, 1.13.1
testing, 1.13.2.1
Database Monitor
I/O, 4.8.1.4
Locks, 4.8.1.2
Long Operations, 4.8.4
Open Cursors, 4.8.1.6
Sessions, 4.8.1, 4.8.1.1
SQL, 4.8.1.5
Top SQL, 4.8.3
Waits, 4.8.1.3
database monitoring
system statistics, 4.8.2
database objects
purging, 4.5
restoring, 4.5
database security
Column Privileges report, 4.4.2
Role Privileges report, 4.4.2
System Privileges report, 4.4.2
DDL
generating, 4.3

E

Excel
importing, 4.2.2.2
Explain Plan
using, 3.11, 3.11.2
Export XML Wizard, 4.2.3.2
exporting data
summary of available methods, 4.1.1

F

function
browsing, 1.11.2
compiling, 1.11.4
creating, 1.11.1
downloading, 1.11.5
dropping, 1.11.6
editing, 1.11.3

I

imported text data
viewing, 4.2.4
importing data
summary of available methods, 4.1.1
index
browsing, 1.6.2
creating, 1.6.1
disabling, 1.6.2, 1.6.2.1
dropping, 1.6.3
rebuilding, 1.6.2, 1.6.2.1
statistics about, 1.6.2.1
I/O report, 4.8.1.4

L

Load Data Wizard, 4.2.2.1
Load XML Wizard, 4.2.2.3
loaded text data
deleting, 4.2.4
Locks report, 4.8.1.2

M

materialized view
browsing, 1.14.2
creating, 1.14.1
dependent objects, 1.14.2.1
dropping, 1.14.3
list of grants, 1.14.2.1
report of data, 1.14.2.1
sort by column, 1.14.2.1
viewing object details, 1.14.2.1

O

Object Browser
about, 1.1
accessing, 1.1.1
creating objects, 1.3
Detail pane, 1.1
Hide Objects control, 1.2.2
hiding Object Selection pane, 1.2.2
managing database links, 1.13
managing functions, 1.11
managing indexes, 1.6
managing materialized views, 1.14
managing packages, 1.9
managing procedures, 1.10
managing sequences, 1.7
managing tables, 1.4
managing triggers, 1.12
managing types, 1.8
managing views, 1.5
Object Selection pane, 1.1
searching for objects, 1.2
synonyms, 1.15
Object Reports
All Objects, 4.4.5
All Objects report, 4.4.5
Column Privileges report, 4.4.2
Data Dictionary, 4.4.5
Exception Reports, 4.4.4
Invalid Objects, 4.4.5
Object Calendar, 4.4.5
Object Counts by Type, 4.4.5
PL/SQL Source Code report, 4.4.3.3
Program Unit Arguments report, 4.4.3.1
Role Privileges report, 4.4.2
System Privileges report, 4.4.2
Unit Line Counts report, 4.4.3.2
objects
purging, 4.5
restoring, 4.5
Open Cursors report, 4.8.1.6
Oracle Optimizer
Explain Plan, 3.11, 3.11.2

P

package
compiling, 1.9.4
creating, 1.9.1
downloading, 1.9.2.1, 1.9.5
dropping, 1.9.6
editing, 1.9.2.1, 1.9.3
finding, 1.9.2.1
grants for, 1.9.2.1
object dependencies, 1.9.2.1
package body, 1.9.2.1
related errors, 1.9.2.1
viewing, 1.9.2
procedure
browsing, 1.10.2
compiling, 1.10.4
creating, 1.10.1
downloading, 1.10.5
dropping, 1.10.6
editing, 1.10.3
editing manually, 1.10.3.1
finding, 1.10.2.1

Q

Query Builder, 5
about, 5.1
accessing, 5.1.1
Conditions tab, 5.4
creating joins automatically, 5.5.3
creating joins manually, 5.5.2
creating relationships between objects, 5.5
filtering objects, 5.2.1
hiding objects in Design Pane, 5.3.3
Object Selection pane, 5.2, 5.2.2
removing objects in Design Pane, 5.3.3
resizing panes, 5.3.2.1
Results tab, 5.8
Saved SQL tab, 5.6.2
saving queries, 5.6
searching for objects, 5.2.1
specifying query conditions, 5.4
supported column types, 5.3, 5.3.1
Table Actions, 5.5.3
View Actions, 5.5.3
viewing generated SQL, 5.7
viewing query results, 5.8

R

Recycle Bin
purging, 4.5
searching, 4.5
using, 4.5
viewing objects, 4.5
reports
Data Dictionary, 4.4.5
database objects, 4.4.5
exception reports, 4.4.4
PL/SQL Source Code, 4.4.3.3
Program Unit Arguments, 4.4.3.1
Unit Line Counts report, 4.4.3.2
results, 2.2.1

S

scripts
creating in editor, 2.3.1
deleting from editor, 2.5.2
deleting from SQL Scripts page, 2.5.1
executing, 2.7
executing from SQL Scripts page, 2.7.2
executing in editor, 2.7.1
export, 2.2.1
exporting, 2.9
importing, 2.9
results, 2.2.1
SQL Script editor, 2.4
uploading to another account, 2.2.1
uploading to SQL Scripts, 2.3.2
viewing repository quotas, 2.10
Security reports
Column Privileges report, 4.4.2
sequence
altering, 1.7.2.1
browsing, 1.7.2
creating, 1.7.1
dependent objects, 1.7.2.1
dropping, 1.7.3
grants associated with, 1.7.2.1
session
killing, 4.8.1.1
Session report, 4.8.1.1
spreadsheets
importing, 4.2.2.2
SQL Commands
command termination, 3.5.4
Explain Plan, running, 3.11, 3.11.2
home page, 3.4
transaction support, 3.5.2
SQL report, 4.8.1.5
SQL Scripts
accessing, 2.2
creating script in editor, 2.3.1
deleting script from editor, 2.5.2
deleting script from SQL Scripts home page, 2.5.1
executing script from SQL Scripts page, 2.7.2
executing script in editor, 2.7.1
exporting scripts, 2.9
importing scripts, 2.9
script editor, 2.4
SQL Scripts page, 2.2.1
uploading script, 2.3.2
viewing quotas, 2.10
viewing script results, 2.8.1
SQL Scripts page
accessing Manage Script Results, 2.2.1
Show Quotas, 2.2.1
Task list, 2.2.1
SQL Scripts page Task list
export scripts, 2.2.1
uploading scripts, 2.2.1
SQL Workshop
about, 3.2
SQL*Plus command support, 3.5.3
SQL*Plus commands
unsupported, 3.5.3
synonym
creating, 1.15.1
dropping, 1.15.3
viewing, 1.15.2

T

tab-delimited file
loading, 4.2.2.1
tables
add column, 1.4.3
browsing, 1.4.2
constraints, 1.4.2.1
copy, 1.4.3
creating, 1.4.1
drop column, 1.4.3
dropping, 1.4.4
editing, 1.4.3
exports data to spreadsheet, 1.4.2.1
grants on, 1.4.2.1
indexes associated, 1.4.2.1
insert row, 1.4.2.1
modify column, 1.4.3
remove all rows, 1.4.3
rename, 1.4.3
rename column, 1.4.3
report of number of rows, 1.4.2.1
sort by column, 1.4.2.1
statistics about, 1.4.2.1
user interface defaults, 1.4.2.1
viewing data, 1.4.2.1
Text Data Load Repository, 4.2.4
text file
loading, 4.2.2.1
transaction support, 3.5.2
trigger
browsing, 1.12.2
compiling, 1.12.4
creating, 1.12.1
downloading, 1.12.5
dropping, 1.12.6
editing, 1.12.3
type
browsing, 1.8.2
creating, 1.8.1
dropping, 1.8.3
grants associated with, 1.8.2.1
list of synonyms, 1.8.2.1

U

Unload to Text Wizard, 4.2.3.1
Unload to XML Wizard, 4.2.3.2
Utilities
Data Dictionary, 4.4.5
utilities
about, 4
comparing schemas, 4
generating DDL, 4
loading data, 4
monitoring the database, 4
restoring dropped objects, 4
unloading data, 4
viewing database details, 4
viewing object reports, 4

V

view
browsing, 1.5.2
compiling, 1.5.4
creating, 1.5.1
dropping, 1.5.5
editing, 1.5.3
grants associated with, 1.5.2.1
objects referenced by, 1.5.2.1
report of data, 1.5.2.1
user interface defaults, 1.5.2.1

W

Waits report, 4.8.1.3
wizards
copying and pasting tab-delimited data, 4.2.2.1
exporting contents of table, 4.2.3.1
exporting text file, 4.2.3.1
exporting XML, 4.2.3.2
importing text, 4.2.2.1
importing XML, 4.2.2.3

X

XML document
exporting to, 4.2.3.2
loading, 4.2.2.3