- 博客(0)
- 资源 (7)
- 收藏
- 关注
PL/SQL Developer完整中文手册
很详细,很好用:
==================================================
1. 介绍 ................................................................................................................................................. 9
2. 安装 ............................................................................................................................................... 13
2.1 系统需求 ...................................................... 13
2.2 工作站安装 .................................................... 13
2.3 基于服务器的安装 .............................................. 13
2.4 脚本安装 ...................................................... 14
2.5 卸载 PL/SQL DEVELOPER ........................................... 14
3. 编写程序 ....................................................................................................................................... 15
3.1 创建程序 ...................................................... 15
3.2 保存程序 ...................................................... 16
3.3 修改程序 ...................................................... 17
3.4 编译程序 ...................................................... 17
3.5 编译器首选项 .................................................. 18
4. 测试程序 ....................................................................................................................................... 19
4.1 创建测试脚本 .................................................. 19
4.2 运行测试脚本 .................................................. 20
4.3 变量类型 ...................................................... 21
4.4 保存测试脚本 .................................................. 22
4.5 跟踪运行时错误 ................................................ 23
4.6 包状态和 JAVA 会话状态 ......................................... 23
4.7 查看结果集 .................................................... 24
4.8 查看 DBMS_OUTPUT ................................................ 24
4.9 查看 HTP 输出 ................................................. 24
4.10 调试 .......................................................... 24
4.11 跟踪运行 ...................................................... 28
4.12 回归测试 ...................................................... 29
5. 优化 ............................................................................................................................................... 30
5.1 使用解释计划窗口 .............................................. 30
5.2 自动统计 ...................................................... 31
5.3 PL/SQL 概览图 ................................................. 32
5.4 SQL 跟踪 ...................................................... 33
6. 专用 SQL ....................................................................................................................................... 35
6.1 使用 SQL 窗口 ................................................. 35
6.2 结果表格处理 .................................................. 36
6.3 实例模式查询 .................................................. 41
6.4 连接查询 ...................................................... 42
6.5 置换变量 ...................................................... 43
6.6 更新数据库 .................................................... 44
6.7 查看和编辑 XMLTYPE 列 .......................................... 45
6.8 直接查询导出 .................................................. 45
6.9 保存 SQL 脚本 .................................................. 45
6.10 创建标准查询 .................................................. 46
7. 命令窗口 ....................................................................................................................................... 47
7.1 输入 SQL 语句和命令 ............................................ 47
7.2 开发命令文件 .................................................. 48
7.3 支持命令 ...................................................... 49
8. 创建和修改非 PL/SQL 对象........................................................................................................ 52
8.1 表定义编辑器 .................................................. 53
8.2 序列定义编辑器 ................................................ 65
8.3 同义词定义编辑器 .............................................. 65
8.4 库定义编辑器 .................................................. 66
8.5 目录定义编辑器 ................................................ 66
8.6 作业定义编辑器 ................................................ 67
8.7 队列定义编辑器 ................................................ 67
8.8 队列表定义编辑器 .............................................. 68
8.9 用户定义编辑器 ................................................ 69
8.10 角色定义编辑器 ................................................ 72
8.11 概要文件定义编辑器 ............................................ 73
8.12 数据库连接定义编辑器 .......................................... 73
9. DBMS 调度程序 .............................................................................................................................. 74
9.1 创建对象 ...................................................... 80
9.2 编辑对象 ...................................................... 80
9.3 删除对象 ...................................................... 80
9.4 查看作业运行 .................................................. 80
9.5 查看正在运行的作业 ............................................ 82
10. 图表 ............................................................................................................................................... 83
10.1 创建图表 ...................................................... 83
10.2 缩放 .......................................................... 87
10.3 保存和打开图表文件 ............................................ 87
10.4 更新图表 ...................................................... 87
10.5 打印图表 ...................................................... 88
10.6 导出图表 ...................................................... 88
11. 报告 ............................................................................................................................................... 89
11.1 标准报告 ...................................................... 89
11.2 定制报告 ...................................................... 90
11.3 变量 .......................................................... 91
11.4 精制版面 ...................................................... 96
11.5 风格库 ....................................................... 103
11.6 选项 ......................................................... 104
11.7 报告菜单 ..................................................... 106
12. 图形 ............................................................................................................................................. 107
13. 工程 ............................................................................................................................................. 109
13.1 创建一个新工程 ............................................... 109
13.2 保存工程 ..................................................... 110
13.3 添加文件到工程 ............................................... 110
13.4 添加数据库对象到工程 ......................................... 110
13.5 用工程项目工作 ............................................... 111
13.6 编译工程 ..................................................... 112
14. 任务项目 ..................................................................................................................................... 113
14.1 创建任务项目 ................................................. 114
14.2 编辑任务项目 ................................................. 114
14.3 关闭任务项目 ................................................. 115
14.4 删除任务项目 ................................................. 115
15. 窗口、数据库会话和事务 ......................................................................................................... 116
15.1 会话模式 ..................................................... 116
15.2 运行于多路会话或双路会话模式 ................................. 116
16. 浏览对象 ..................................................................................................................................... 117
16.1 使用对象浏览器 ............................................... 117
16.2 对象浏览器过滤器 ............................................. 124
16.3 对象浏览器文件夹 ............................................. 125
17. 浏览文件 ..................................................................................................................................... 127
17.1 设置文件浏览器 ............................................... 127
17.2 使用文件浏览器 ............................................... 129
18. 首选项 ......................................................................................................................................... 130
18.1 ORACLE – 连接 ................................................. 131
18.2 ORACLE – 选项 ................................................. 132
18.3 ORACLE – 编译器 ............................................... 134
18.4 ORACLE – 调试器 ............................................... 136
18.5 ORACLE – 输出 ................................................. 137
18.6 ORACLE – 跟踪 ................................................. 138
18.7 ORACLE – 概览图 ............................................... 138
18.8 ORACLE – 登录历史 ............................................. 140
18.9 ORACLE – 提示 ................................................. 141
18.10 用户界面 – 选项 ............................................. 143
18.11 用户界面 – 工具栏 ........................................... 145
18.12 用户界面 – 对象浏览器 ....................................... 145
18.13 用户界面 – 编辑器 ........................................... 147
18.14 用户界面 – 字体 .............................................. 150
18.15 用户界面 – 代码助手 .......................................... 151
18.16 用户界面 – 键配置 ............................................ 152
18.17 用户界面 – 外观 .............................................. 153
18.18 用户界面 – NLS 选项 .......................................... 155
18.19 窗口类型 – 程序窗口 .......................................... 157
18.20 窗口类型 – SQL 窗口 .......................................... 159
18.21 窗口类型 – 测试窗口 .......................................... 161
18.22 窗口类型 – 计划窗口 .......................................... 162
18.23 工具 – 差异 .................................................. 162
18.24 工具 – 数据生成器 ............................................ 163
18.25 工具 – 任务列表 .............................................. 163
18.26 工具 – 重新调用声明 .......................................... 164
18.27 文件 – 目录 .................................................. 165
18.28 文件 – 扩展名 ................................................ 167
18.29 文件 – 格式 .................................................. 167
18.30 文件 – 备份 .................................................. 168
18.31 文件 – HTML/XML .............................................. 169
18.32 其他 – 打印 .................................................. 170
18.33 其他 – 更新与消息 ............................................ 171
18.34 首选项集 ..................................................... 172
19. 工具 .............................................................................................................................................174
19.1 对象浏览器 ................................................... 174
19.2 查找数据库对象 ............................................... 175
19.3 编译无效对象 ................................................. 176
19.4 导出表 ....................................................... 177
19.5 导入表 ....................................................... 180
19.6 导出用户对象 ................................................. 182
19.7 文本导入器 ................................................... 183
19.8 ODBC 导入器 ................................................... 188
19.9 数据生成器 ................................................... 190
19.10 比较用户对象 ................................................. 194
19.11 比较表数据 ................................................... 196
19.12 事件监视器 ................................................... 199
19.13 会话 ......................................................... 200
19.14 自定义工具 ................................................... 202
19.15 测试管理器 ................................................... 207
20. 编辑器 .........................................................................................................................................211
20.1 选择功能 ..................................................... 211
20.2 列选择 ....................................................... 211
20.3 代码助手 ..................................................... 212
20.4 重新调用语句 ................................................. 213
20.5 专用复制 ..................................................... 214
20.6 前后关系敏感帮助 ............................................. 215
20.7 数据库对象弹出式菜单 ......................................... 215
20.8 解释计划 ..................................................... 215
20.9 宏 ........................................................... 215
20.10 书签 ......................................................... 216
20.11 颜色标记 ..................................................... 217
20.12 代码目录 ..................................................... 218
20.13 代码层次 ..................................................... 219
20.14 代码折叠 ..................................................... 219
20.15 拆分编辑 ..................................................... 220
20.16 超链接导航 ................................................... 221
20.17 导航按钮 ..................................................... 221
20.18 重构 ......................................................... 222
20.19 搜索栏 ....................................................... 222
21. 大数据编辑器 ............................................................................................................................. 224
21.1 编辑纯文本 ................................................... 225
21.2 编辑 RTF ..................................................... 225
21.3 编辑 XML ..................................................... 226
21.4 编辑图象 ..................................................... 227
21.5 编辑十六进制数据 ............................................. 227
21.6 调用外部查看器或编辑器 ....................................... 229
22. 查询设计器 ................................................................................................................................. 231
22.1 创建新的 SELECT 语句 ........................................... 231
22.2 修改现有的SELECT 语句 .......................................... 235
22.3 处理查询定义 ................................................. 235
22.4 查询设计器首选项 ............................................. 236
22.5 查询设计器插件 ............................................... 237
23. PL/SQL 美化器 ........................................................................................................................... 238
23.1 定义选项 ..................................................... 238
23.2 定义规则 ..................................................... 239
23.3 使用美化器 ................................................... 240
23.4 取消格式化 ................................................... 240
24. 模板 ............................................................................................................................................. 241
24.1 模板窗口 ..................................................... 241
24.2 使用模板 ..................................................... 242
24.3 创建和修改模板 ............................................... 243
25. 窗口列表 .....................................................................................................................................248
26. 可停放和浮动的工具 ..................................................................................................................249
27. 授权 .............................................................................................................................................251
27.1 允许授权 ..................................................... 251
27.2 定义授权 ..................................................... 252
27.3 禁用授权 ..................................................... 253
28. ORACLE 文件系统 (OFS) ............................................................................................................254
28.1 OFS 管理器 .................................................... 254
28.2 OFS 用法 ...................................................... 256
29. 帮助系统 .....................................................................................................................................258
29.1 MS 帮助文件 ................................................... 258
29.2 HTML 手册 ..................................................... 258
30. 定制 .............................................................................................................................................262
30.1 首选项 ....................................................... 262
30.2 窗口版面 ..................................................... 262
30.3 在线文档 ..................................................... 262
30.4 命令行参数 ................................................... 264
30.5 SQL、PL/SQL、命令、JAVA 和 XML 关键词 .......................... 267
30.6 插件 ......................................................... 267
2012-09-27
最完整的Toad For Oracle使用手册
1073页啊,够爽吧:
Introduction 15
New in This Release 15
Introduction to Toad 23
DB Admin Module 24
Toad and Oracle Enterprise Manager 29
Quick Search Bar 30
Additional Resources 31
Working with other Quest Products 32
Knowledge Xpert 32
Using SQL Optimizer with Toad 32
Benchmark Factory 33
Quest Code Tester Integration 35
Toad Basics 37
Toad Tips 37
Errors 37
RAC Support 37
Task Bar & Status Bar 38
Toolbars, Menus and Shortcut Keys 40
Installation and Administration of Toad 64
Window Privileges and Toad 64
Toad for Oracle, Read-Only 64
Registering Toad 65
Silent Installation 66
Group Policy Management 71
Citrix Support 71
SQL*Net Versions 72
Configuration Files 73
Server Side Objects Installation 93
Connecting to Oracle 97
Server Login Window 97
Create New Connection 99
Selecting Connection Color 101
SET ROLE 101
Auto Connect 103
Save Passwords for Connections 104
Select and View Favorite Connections 104
Organize your login display 105
Use Existing Connection 106
SQLNET Editor 106
LDAP Editor 107
Oracle Homes 108
TNSNames Editor 111
Tutorials 119
CodeXpert 119
PL/SQL Debugger 121
SQL*Loader 140
Team Coding 158
RMAN Templates 164
RMAN Scripts in Toad 164
Working with RMAN Templates 164
Executing RMAN Scripts from Toad 165
Comparing 166
Data Duplicates 166
Compare Single Objects 166
Comparing Databases 167
Comparing Data 174
Compare Files (Difference Viewer) 176
Comparing Schemas 180
Controlling Sessions 188
Select Session 188
End Connections 188
Test Connections 188
Configure User Lists 188
Session Information 189
Change Password 190
Commit & Rollback 190
Connect and Disconnect 191
DBMS_Flashback 191
Diagnosing Problems 193
View Extents 193
Identify Space Deficits 193
Log Switch Frequency Map 194
Tablespace Map 194
TKProf Interface Wizard 196
Undo Advisor 198
Segment Advisor 200
LogMiner Interface 203
Health Check 207
Trace File Browser 226
CodeXpert 231
Database Administration 259
Audit SQL/Sys Privs 259
NLS Parameters 260
Toad Features Security 260
ASM Manager 263
Audit Objects 269
Multiple Object Privileges 270
Oracle Parameters 272
Tablespaces 274
Redo Log Manager 282
Importing and Exporting Data 285
Data Pump 285
Export Dataset 304
Export DDL 310
Export File Browser 318
General Export 324
General Import 329
Generate Database Script 341
Generate Schema Script 342
Managing Projects 346
Using Automation Designer to Control Toad 346
Project Manager 387
Query Viewer 416
SQL Command Recall 418
Script Manager 419
Monitoring 431
Toad Server Statistics 431
SQL Monitor 432
Toad UNIX Monitor 432
ADDM/AWR 434
Database Browser 446
Database Monitor 449
Database Probe 453
Index Monitoring 458
Instance Manager 460
Session Browser 466
SGA Trace/Optimization 483
StatsPack Browser 486
Top Session Finder 495
Optimizing (Tuning) 499
DBMS_REDEFINITION Wizard 499
Estimate Index Size 500
Estimate Table Size 501
Explain Plan 503
Pinned Code 504
Repair Chained Rows 505
Rebuild Table 506
Unix Kernel Parms 507
Windows Registry Parms 508
Analyze All Objects 509
Profilers 512
Oracle Tuning 523
Rebuild Multiple Objects 525
Options 535
Formatting Options 535
Toad Options 536
Language Management 603
Printing 620
Printing 620
Print Grid 620
Report Link Designer 620
Reporting 623
Toad Control Files 623
Dependencies 624
ER Diagrams 624
Explain Plans 631
Code Road Map 636
HTML Schema Doc Generator 641
Master/Detail Browser 643
Reports Manager 648
Reporting from Data Grids 655
Spool SQL 659
Spool SQL 659
Utilities 660
Archive 660
Wrap Code 660
Service Manager 661
External tools 662
FTP 665
Java Manager 668
Network Utilities 672
Task Scheduler 676
Unix Job Scheduler 678
Source Control and Team Coding 693
Support for Version Control Products 693
Third Party File Based Source Control 694
Team Coding 697
Status in the Editor Status Bar or Team Coding Viewer Status Column 707
Detailed File Properties 708
Checking Objects and Scripts in and out 709
Using Automatic Check-in and Automatic Check-out 709
Manually check-in or check-out 709
Entering Comments on Check in or out 710
Check In All 711
Undo Checkout 712
Freezing an Object 713
TC Locks not selected 726
TC Locks selected 726
Working from the Command Line 738
Command Line Syntax 738
Converting Old Settings Files to Actions 743
Command Line Passwords 744
Export Tables, Views, SQL Queries from the Command Line 744
Run Analyze Objects from the Command Line 745
Run CodeXpert from the Command Line 750
Running Actions from the Command Line 751
Run Compare Databases from Command Prompt 754
Run Compare Schemas from a Command Prompt 757
Run Copy to another Schema from Command Prompt 757
Run Generate Database Script from a Command Prompt 758
Run Generate Schema Script from Command Line 760
Run Rebuild Objects from the Command Prompt 762
Run Reports Manager from the Command Line 766
Using Variables 768
Using Variables 768
Working with Code 769
Editor 769
Debugging 819
Query Builder 851
Working with Data 861
Column Names Supported 861
Graph Properties 861
OPS$ Accounts 861
Viewing or Hiding Docked Windows 862
Viewing Source Surrounding a PL/SQL Error 863
Dataset Operations 864
Data Grids 866
DBMS Output 881
Finding Data 883
Generate Test Data 890
Working with Database Objects 896
Schema Browser Overview 896
Auto-Refreshing the Datagrid 897
Icon Legend 898
Privileges 898
Schema Browser Toolbars 899
Statement Processing 900
Create Objects in Another Schema 900
Personalizing the Schema Browser 900
General Schema Browser Actions 903
Browser Filters 907
Clusters 912
Constraints 914
Contexts 917
DB Links 918
Dimensions 920
Directories 921
Favorites 923
Flashback Archives 924
Functions 926
Indexes 928
Invalid Objects 929
Java 931
Jobs 933
Libraries 936
Materialized Views (Snapshots) 938
Materialized View (Snapshot) Logs 940
Oracle Scheduler 941
Packages 953
Policies 955
Policy Groups 956
Procedures 957
Profiles 959
Queue Tables 960
Queues 964
Recycle Bin 966
Refresh Groups 968
Resource Consumer Groups 970
Resource Plans 972
Roles 974
Rollback Segments 975
Sequences 977
Synonyms 978
System Privileges 980
Tables 981
Tablespaces 996
Triggers 1002
Types 1004
Users 1010
Views 1012
Troubleshooting 1017
Unicode Troubleshooting 1017
Hints and Tips: Connecting To Personal Oracle 1018
Hints and Tips: Table Does Not Exist Errors 1019
Create Support Bundles 1019
Toad Advisor 1019
Contact Quest 1021
Contact Quest Support 1021
Contact Quest Software 1021
About Quest Software, Inc 1021
Appendix: Contact Quest 1022
Contact Quest Support 1022
Contact Quest Software 1022
About Quest Software, Inc 1022
Index 1023
2012-09-22
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人