120
|
Index
ROLLBACK, prompting for, 8
“Run Explain Plan for current
statement” button, 45
S
Sarbanes-Oxley Act, 105
Save As function, 39
“Save Options to File”
button, 40
saved statements, recalling, 27
SAVEDSQL.xml file, 27
saving
data in data grids, 39
.tpr (project) files, 111
SBQueries.dat file, 9
SCC (Source Code Control)
standard, 22
Schema Browser, 50–59
added functionality from DBA
Module, 83
configuring, 51–54
exporting data, 96
tablespace statistics,
displaying, 92
user administration tasks, 101
schemas
comparing, 97
creating HTML
documentation for, 100
Script Debugger feature, 26
Script Debugging toolbar (SQL
Editor), 14
Script Navigation panel (SQL
Editor), 13
Script Output tab (SQL
Editor), 24
scripts, executing multiple
statements as, 24
scrolling down through result
sets, 36
scrolling left to right through
result sets, 37
Search in All Schemas filtering
option, 59
Security facility for Toad, 103
Select Session function, 58
SELECT statements, parsing, 25
ServerSide Objects Wizard
(Toad), 6
Session Browser window, 49,
88–89
session-modifiable
parameters, 87
Set Schema function, 15
SGA Trace Optimization
function, 47, 98
sharing .tpr (project) files, 111
shortcut keys
for Procedure Editor, 66
for SQL Editor, 18–21
for Toad, defining, 12
“Show Previous Explain Plan
Results” button, 45
Single Record View,
accessing, 39
Source Code Control (SCC)
standard, 22
Source Code function, 97
Source Control toolbar (SQL
Editor), 15
SQL Command Recall menu
item, 27, 29
SQL Editor, 12–33
executing statements
in, 23–26
EXPLAIN PLAN
command, 45
parsers/languages,
supporting, 21
Right Mouse menu, 18
Script Debugger feature, 26
shortcut keys for, 18–21
SQL*Plus commands,
executing, 24
working with files in, 22
Index
|
121
SQL Editor menu, 10, 16
SQL Loader wizard, 43
SQL optimization, 44–50
SQL Optimization/SQL Rewrite
tool, 50
SQL Optimizer for Oracle, 50
SQL Recall toolbar (SQL
Editor), 15
SQL Scanner tool, 50
SQL Trace (TKPROF) utility, 47
SQL*Plus commands,
executing, 24
Standard (Common) Edit toolbar
(SQL Editor), 14
Standard toolbar (Toad), 12
startup options for Toad, 7
startup, opening windows at, 8
statements
adding development code
syntax to, 30
cancelling, 26
executing, 23–26
parsing, 25
recalling saved statements, 27
removing development code
syntax from, 30
storing/reusing single-line
statements, 29
stored programs, running from
Debugger, 77
“Strip All Non-SQL Syntax”
button, 30
substitution variables, using in
SQL Editor, 26
Summary Report tab
(CodeXpert), 80
symbol table, cleaning up after
debugging, 78
synonyms for schemas,
displaying, 28
system-modifiable
parameters, 87
T
Table as Flat File function, 97
Table Data Duplicates
window, 44
Table Data function, 96
tables
displaying column dropdown
for, 32
Import Table Data wizard, 43
for schemas, displaying, 28
viewing/editing data with
Master Detail Browser, 42
tablespace maps, 91–93
tablespaces, managing, 90–93
Team Coding (Toad), 11, 22
templates
code completion, 32, 67
customizing, 67
TKPROF interface, 47
TNSNAMES.ora file, 85
Toad
AutoTrace feature, 46
code completion templates
in, 32, 67
configuring, 6
data grids in, 33–44
EDIT command, 30
executing statements in, 23–26
expanding functionality of, 6
installing, 6
Menu toolbar, 10–12
optimizing SQL, 44–50
Oracle and, 5
Procedure Editor, 59–69
Project Manager
(PM), 107–112
properties files for, 9
SCC (Source Code Control)
standard and, 22
Schema Browser, 50–59, 83
startup options for, 7
Team Coding and, 22
122
|
Index
Toad Describe facility, 31
Toad for Oracle, 113
Oracle Probe Profiler API, 78
Toad for Oracle Professional
Edition, 113
CodeXpert utility, 78–82
debugging module for, 70–82
Toad for Oracle Suite, 113–114
Toad for Oracle Xpert
Edition, 113
SQL Optimizer for Oracle, 50
Toad Security facility, 103
Toad ServerSide Objects
Wizard, 6
Toad Standard toolbar, 12
Toad.ini file, 9
Toad_GUI.ini, 9
Toad_SESSBROWFILTERS.ini
file, 9
Toad-DBA Module, 83–85, 114
modifying Oracle
parameters, 87
ToadParams.ini file, 71
“Toggle reorder mode”
button, 112
toolbars
for CodeXpert utility, 81
for SQL Editor, 13–18
Tools menu, 11
Top Session Finder, 9, 88
TopSess.ini file, 9
.tpr (project) files
creating, 109–110
saving/sharing, 111
traces
enabling/disabling for user
sessions, 49
SGA Trace Optimization
function, 47, 98
SQL Trace (TKPROF)
utility, 47
transactions
debug sessions and, 71
prompting for commit/
rollback, 8
.trc files, 112
U
URL project nodes, 109
user administration, 100–107
V
Variables input window, 26
version control software and
Toad, 22
View menu, 11
View/Edit Privileges for this
object type button, 56
views for schemas, displaying, 28
Visual options
for data grids, 35
for Schema Browser, 51
W
Watches tab (Debugger), 74
Window menu, 12
windows, opening at startup, 8
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.