没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
®
USER’S GUIDE
Version 7.5
© Copyright Quest Software, Inc. 2000-2003. All Rights Reserved.
This guide contains proprietary information, which is protected by copyright. The
software described in this guide is furnished under a software license or nondisclosure
agreement. This software may be used or copied only in accordance with the terms of
the applicable agreement. No part of this guide may be reproduced or transmitted in
any form or by any means, electronic or mechanical, including photocopying and
recording, for any purpose other than the purchaser’s personal use without the written
permission of Quest Software, Inc.
Warranty
The information contained in this document is subject to change without notice. Quest
Software makes no warranty of any kind with respect to this information. QUEST
SOFTWARE SPECIFICALLY DISCLAIMS THE IMPLIED WARRANTY OF THE
MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. Quest
Software shall not be liable for any direct, indirect, incidental, consequential, or other
damage alleged in connection with the furnishing or use of this information.
Trademarks
Quest® and TOAD® are registered trademarks of Quest Software, Inc. Other
trademarks and registered trademarks used in this guide are the property of their
respective owners.
Quest Software, Inc.
World Headquarters
8001 Irvine Center Drive
Irvine, CA 92618
www.quest.com
U.S. and Canada 949.754.8000
email: info@quest.com
TOAD User's Guide
Updated April 2003
Software Version 7.5
Contents
CONTENTS
TOAD User’s Guide
1 INTRODUCTION........................................................................................................................... 7
2 LOGON/LOGOFF.......................................................................................................................... 9
L
OGON OPTIONS ............................................................................................................................. 12
C
ONNECTING TO PERSONAL ORACLE.............................................................................................. 17
E
ND CONNECTION .......................................................................................................................... 17
3 SCHEMA PREPARATION......................................................................................................... 19
4 BASICS .......................................................................................................................................... 21
M
OUSE............................................................................................................................................ 21
K
EYBOARD ..................................................................................................................................... 23
H
OTKEYS – ADDING/ALTERING....................................................................................................... 25
R
IGHT-CLICK MENUS ...................................................................................................................... 26
M
AIN TOOLBAR .............................................................................................................................. 27
Configure TOAD Options ..........................................................................................................29
Save TOAD Options................................................................................................................... 29
Offline Text Editor ..................................................................................................................... 30
Configure/Execute External Tools ............................................................................................. 30
Project Manager ........................................................................................................................ 31
Customize (toolbars and menus)................................................................................................ 33
Menu Shortcut Customization window....................................................................................... 35
5 SQL EDITOR................................................................................................................................ 37
SQL E
DITOR TOOLBAR................................................................................................................... 38
S
HORTCUT KEYS............................................................................................................................. 38
U
SING THE SQL EDITOR................................................................................................................. 43
Selecting a table to edit.............................................................................................................. 43
Commit....................................................................................................................................... 46
Explain Plan............................................................................................................................... 48
Recall and Add SQL................................................................................................................... 53
O
PTIONS FOR THE SQL EDITOR ...................................................................................................... 59
E
XECUTING STATEMENTS............................................................................................................... 64
Execute SQL Scripts................................................................................................................... 65
4
Table/View Aliases..................................................................................................................... 67
C
ONFIGURING THE EDITOR ............................................................................................................. 70
E
DITOR OPTIONS............................................................................................................................. 80
General Options......................................................................................................................... 81
Highlighting ............................................................................................................................... 89
Key Assignments......................................................................................................................... 93
Auto Replace .............................................................................................................................. 95
Code Templates.......................................................................................................................... 97
R
IGHT-CLICK MENU ........................................................................................................................ 99
SQL R
ESULTS PANEL ................................................................................................................... 100
Data tab ................................................................................................................................... 100
Explain Plan tab....................................................................................................................... 105
Auto Trace tab.......................................................................................................................... 106
DBMS Output tab..................................................................................................................... 107
Script Output............................................................................................................................ 107
SQL T
EMPLATES .......................................................................................................................... 108
M
AKE CODE STATEMENT AND STRIP CODE STATEMENT.............................................................. 110
O
PTIONS FOR THE EDITORS ........................................................................................................... 113
SQL E
DITOR TASKS...................................................................................................................... 118
6 DATA GRIDS.............................................................................................................................. 127
R
IGHT-CLICK MENU ...................................................................................................................... 127
S
ORT OPTIONS WINDOW............................................................................................................... 139
C
ALCULATOR................................................................................................................................ 140
D
ATA GRIDS – DATA OPTIONS ..................................................................................................... 141
D
ATA GRIDS – VISUAL OPTIONS................................................................................................... 145
R
EPORT LINK DESIGNER............................................................................................................... 151
7 PROCEDURE EDITOR............................................................................................................. 155
P
ROCEDURE EDITOR TOOLBARS ................................................................................................... 156
S
HORTCUT KEYS........................................................................................................................... 157
P
ARAMETER HINTS ....................................................................................................................... 159
U
SING THE PROCEDURE EDITOR ................................................................................................... 160
N
AVIGATOR TREE BUTTONS ......................................................................................................... 166
O
PTIONS FOR THE PROCEDURE EDITOR......................................................................................... 167
R
IGHT-CLICK MENU ...................................................................................................................... 171
DBMS O
UTPUT ............................................................................................................................ 173
UTPLSQL ..................................................................................................................................... 175
S
OURCE CODE MANAGEMENT ...................................................................................................... 177
T
EAM CODING .............................................................................................................................. 181
O
PTIONAL PL/SQL DEBUGGER .................................................................................................... 182
Tooltip Feature for Variables .................................................................................................. 184
The Status Panel Indicators ..................................................................................................... 185
Contents 5
The Dockable Windows............................................................................................................ 185
Preparing PL/SQL Code for Production ................................................................................. 186
P
ROCEDURE EDITOR TASKS .......................................................................................................... 187
8 SCHEMA BROWSER................................................................................................................ 193
U
SING THE SCHEMA BROWSER ..................................................................................................... 194
O
PTIONS FOR THE SCHEMA BROWSER .......................................................................................... 198
T
ABLES ......................................................................................................................................... 207
V
IEWS........................................................................................................................................... 229
S
YNONYMS ................................................................................................................................... 229
P
ROCEDURES ................................................................................................................................ 230
T
RIGGERS ..................................................................................................................................... 232
I
NDEXES........................................................................................................................................ 233
C
ONSTRAINTS ............................................................................................................................... 234
S
EQUENCES................................................................................................................................... 234
JAVA ........................................................................................................................................... 234
DB L
INKS ..................................................................................................................................... 235
U
SERS ........................................................................................................................................... 235
J
OBS.............................................................................................................................................. 236
T
YPES ........................................................................................................................................... 236
Q
UEUE TABLES ............................................................................................................................. 236
Q
UEUES ........................................................................................................................................ 236
F
AVORITES.................................................................................................................................... 237
S
CHEMA BROWSER TASKS ............................................................................................................ 238
9 OTHER TOAD OPTIONS AN D FEATURES ........................................................................ 241
Q
UEST SCRIPTRUNNER ................................................................................................................. 242
SQL M
ODELER ............................................................................................................................. 247
C
ODE ROAD MAP.......................................................................................................................... 260
ER D
IAGRAM................................................................................................................................ 261
C
REATE/ALTER TABLE ................................................................................................................. 262
K
ILL/TRACE SESSION.................................................................................................................... 264
TOAD R
EPORTS ........................................................................................................................... 265
HTML S
CHEMA DOC GENERATOR............................................................................................... 266
N
ETWORK UTILITIES..................................................................................................................... 269
O
BJECT SEARCH ........................................................................................................................... 273
M
ASTER/DETAIL RECORD BROWSER............................................................................................. 274
R
EBUILD TABLE............................................................................................................................ 276
TOAD S
ECURITY ......................................................................................................................... 277
J
AVA FEATURES ............................................................................................................................ 279
O
PTIONAL TOAD-DBA MODULE ................................................................................................ 280
10 FREQUENTLY ASKED QUESTIONS/TROUBLESHOOTING....................................... 283
剩余290页未读,继续阅读
资源评论
South-Fly
- 粉丝: 91
- 资源: 15
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功