没有合适的资源?快使用搜索试试~ 我知道了~
首页PLSQL Developer14用户指南.pdf
资源详情
资源评论
资源推荐
PL/SQL Developer 14.0
User’s Guide
February 2020
PL/SQL Developer 14.0 User’s Guide 3
Contents
CONTENTS ........................................................................................................................................... 3
1. INTRODUCTION .................................................................................................................... 10
2. INSTALLATION ..................................................................................................................... 13
2.1 SYSTEM REQUIREMENTS.................................................................................................... 13
2.2 INTERACTIVE INSTALLATION ............................................................................................. 13
2.3 SILENT INSTALLATION....................................................................................................... 13
2.4 UNINSTALLING PL/SQL DEVELOPER ................................................................................ 13
3. LOGGING ON TO AN ORACLE DATABASE .................................................................... 14
4. WRITING PROGRAMS ......................................................................................................... 15
4.1 CREATING A PROGRAM ...................................................................................................... 15
4.2 SAVING A PROGRAM .......................................................................................................... 16
4.3 MODIFYING A PROGRAM ................................................................................................... 17
4.4 COMPILING A PROGRAM .................................................................................................... 17
4.5 COMPARING A PROGRAM ................................................................................................... 18
4.6 COMPILER PREFERENCES ................................................................................................... 19
5. TESTING PROGRAMS .......................................................................................................... 20
5.1 CREATING A TEST SCRIPT ................................................................................................. 20
5.2 EXECUTING A TEST SCRIPT ............................................................................................... 21
5.3 VARIABLE TYPES ............................................................................................................... 22
5.4 SAVING TEST SCRIPTS ....................................................................................................... 23
5.5 TRACKING RUN-TIME ERRORS ........................................................................................... 24
5.6 PACKAGE STATES & JAVA SESSION STATES ....................................................................... 24
5.7 VIEWING RESULT SETS ...................................................................................................... 24
5.8 VIEWING DBMS_OUTPUT ................................................................................................... 24
5.9 VIEWING HTP OUTPUT ...................................................................................................... 25
5.10 DEBUGGING ...................................................................................................................... 25
5.11 TRACING EXECUTION ........................................................................................................ 30
5.12 REGRESSION TESTING ........................................................................................................ 31
5.13 CREATING STANDARD TESTS ............................................................................................ 31
6. OPTIMIZING .......................................................................................................................... 32
6.1 USING THE EXPLAIN PLAN WINDOW ................................................................................. 32
6.2 AUTOMATIC STATISTICS .................................................................................................... 34
6.3 THE PL/SQL PROFILER ..................................................................................................... 35
6.4 SQL TRACE ....................................................................................................................... 35
7. AD HOC SQL ........................................................................................................................... 37
7.1 USING THE SQL WINDOW ................................................................................................. 37
7.2 RESULT GRID MANIPULATION............................................................................................ 39
7.3 QUERY BY EXAMPLE MODE .............................................................................................. 45
7.4 LINKED QUERIES ............................................................................................................... 46
7.5 SUBSTITUTION VARIABLES ................................................................................................ 47
7.6 UPDATING THE DATABASE ................................................................................................ 48
7.7 VIEWING AND EDITING XMLTYPE COLUMNS .................................................................. 49
7.8 COMPARING RECORDS ....................................................................................................... 49
7.9 COMPARING RESULT SETS ................................................................................................. 50
7.10 DIRECT QUERY EXPORT .................................................................................................... 51
7.11 COMMENT DIRECTIVES ...................................................................................................... 51
7.12 SAVING SQL SCRIPTS ....................................................................................................... 52
4 PL/SQL Developer 14.0 User’s Guide
7.13 CREATING STANDARD QUERIES ........................................................................................ 52
8. THE COMMAND WINDOW ................................................................................................. 54
8.1 ENTERING SQL STATEMENTS AND COMMANDS ................................................................ 54
8.2 DEVELOPING COMMAND FILES .......................................................................................... 55
8.3 SUPPORTED COMMANDS.................................................................................................... 55
8.4 EXPORT TABLES COMMAND SYNTAX ................................................................................ 58
8.5 EXPORT OBJECTS COMMAND SYNTAX ............................................................................... 59
9. CREATING AND MODIFYING NON-PL/SQL OBJECTS ................................................ 60
9.1 THE TABLE DEFINITION EDITOR ......................................................................................... 60
9.2 THE SEQUENCE DEFINITION EDITOR .................................................................................. 73
9.3 THE SYNONYM DEFINITION EDITOR ................................................................................... 73
9.4 THE LIBRARY DEFINITION EDITOR ..................................................................................... 74
9.5 THE DIRECTORY DEFINITION EDITOR ................................................................................. 74
9.6 THE JOB DEFINITION EDITOR ............................................................................................. 75
9.7 THE QUEUE DEFINITION EDITOR ........................................................................................ 75
9.8 THE QUEUE TABLE DEFINITION EDITOR ............................................................................. 76
9.9 THE USER DEFINITION EDITOR ........................................................................................... 77
9.10 THE ROLE DEFINITION EDITOR ........................................................................................... 80
9.11 THE PROFILE DEFINITION EDITOR ...................................................................................... 80
9.12 THE DATABASE LINK DEFINITION EDITOR .......................................................................... 81
10. DBMS SCHEDULER .............................................................................................................. 82
10.1 CREATING OBJECTS ........................................................................................................... 89
10.2 EDITING OBJECTS .............................................................................................................. 89
10.3 DELETING OBJECTS ........................................................................................................... 89
10.4 VIEWING JOB RUNS ........................................................................................................... 89
10.5 VIEWING RUNNING JOBS.................................................................................................... 90
11. DIAGRAMS ............................................................................................................................. 91
11.1 CREATING A DIAGRAM ...................................................................................................... 91
11.2 ZOOMING .......................................................................................................................... 94
11.3 SAVING AND OPENING A DIAGRAM FILE ............................................................................ 94
11.4 UPDATING A DIAGRAM ...................................................................................................... 94
11.5 PRINTING A DIAGRAM ....................................................................................................... 95
11.6 EXPORTING A DIAGRAM .................................................................................................... 95
12. REPORTS ................................................................................................................................ 96
12.1 STANDARD REPORTS ......................................................................................................... 96
12.2 CUSTOM REPORTS ............................................................................................................. 97
12.3 VARIABLES ....................................................................................................................... 97
12.4 REFINING THE LAYOUT.................................................................................................... 102
12.5 THE STYLE LIBRARY ....................................................................................................... 108
12.6 OPTIONS .......................................................................................................................... 109
12.7 THE REPORTS MENU ........................................................................................................ 110
13. GRAPHICS ............................................................................................................................ 112
14. PROJECTS ............................................................................................................................ 114
14.1 CREATING A NEW PROJECT .............................................................................................. 114
14.2 SAVING A PROJECT .......................................................................................................... 115
14.3 ADDING FILES TO A PROJECT ........................................................................................... 115
14.4 ADDING DATABASE OBJECTS TO A PROJECT .................................................................... 115
14.5 WORKING WITH PROJECT ITEMS ...................................................................................... 116
14.6 COMPILING A PROJECT .................................................................................................... 117
PL/SQL Developer 14.0 User’s Guide 5
15. WORKSETS........................................................................................................................... 118
15.1 WORKING WITH WORKSETS ............................................................................................. 118
15.2 MANAGING WORKSETS .................................................................................................... 120
15.3 WORKSETS & PROJECTS .................................................................................................. 120
15.4 WORKSETS & VERSION CONTROL ................................................................................... 120
16. VERSION CONTROL .......................................................................................................... 121
16.1 SETTING UP VERSION CONTROL ....................................................................................... 121
16.2 VERSION CONTROL STATUSES ......................................................................................... 121
16.3 VERSION CONTROL OPERATIONS ..................................................................................... 122
17. TO-DO ITEMS....................................................................................................................... 123
17.1 CREATING A TO-DO ITEM ............................................................................................... 124
17.2 EDITING A TO-DO ITEM ................................................................................................... 124
17.3 CLOSING A TO-DO ITEM .................................................................................................. 124
17.4 DELETING A TO-DO ITEM ................................................................................................ 124
18. THE CONNECTION LIST ................................................................................................... 125
18.1 USING THE CONNECTION LIST ......................................................................................... 125
18.2 DEFINING FOLDERS AND CONNECTIONS .......................................................................... 128
19. CONNECTIONS, WINDOWS, SESSIONS AND TRANSACTIONS ............................... 131
19.1 THE MAIN CONNECTION .................................................................................................. 131
19.2 WINDOW CONNECTIONS .................................................................................................. 131
19.3 SESSION MODE ................................................................................................................ 132
19.4 EXECUTION IN MULTI SESSION OR DUAL SESSION MODE................................................. 132
20. BROWSING OBJECTS ........................................................................................................ 133
20.1 USING THE OBJECT BROWSER ......................................................................................... 133
20.2 OBJECT BROWSER FILTERS ............................................................................................. 140
20.3 OBJECT BROWSER FOLDERS ............................................................................................ 141
21. BROWSING FILES ............................................................................................................... 143
21.1 SETTING UP THE FILE BROWSER ...................................................................................... 144
21.2 USING THE FILE BROWSER .............................................................................................. 145
21.3 FILTERS ........................................................................................................................... 146
22. PREFERENCES .................................................................................................................... 147
22.1 ORACLE – CONNECTION .................................................................................................. 148
22.2 ORACLE – OPTIONS ......................................................................................................... 149
22.3 ORACLE – COMPILER ...................................................................................................... 151
22.4 ORACLE – DEBUGGER ..................................................................................................... 153
22.5 ORACLE – OUTPUT .......................................................................................................... 154
22.6 ORACLE – TRACE ............................................................................................................ 155
22.7 ORACLE – PROFILER ........................................................................................................ 156
22.8 ORACLE – LOGON HISTORY ............................................................................................ 157
22.9 ORACLE – HINTS ............................................................................................................. 158
22.10 USER INTERFACE – OPTIONS ........................................................................................... 160
22.11 USER INTERFACE – OBJECT BROWSER ............................................................................ 162
22.12 USER INTERFACE – EDITOR ............................................................................................. 163
22.13 USER INTERFACE – FONTS ............................................................................................... 167
22.14 USER INTERFACE – CODE ASSISTANT ............................................................................. 168
22.15 USER INTERFACE – KEY CONFIGURATION....................................................................... 170
22.16 USER INTERFACE – APPEARANCE .................................................................................... 170
22.17 USER INTERFACE – NLS OPTIONS ................................................................................... 172
22.18 WINDOW TYPES – GENERAL ........................................................................................... 173
22.19 WINDOW TYPES – PROGRAM WINDOW ........................................................................... 174
剩余294页未读,继续阅读
szh123
- 粉丝: 0
- 资源: 4
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- ExcelVBA中的Range和Cells用法说明.pdf
- 基于单片机的电梯控制模型设计.doc
- 主成分分析和因子分析.pptx
- 共享笔记服务系统论文.doc
- 基于数据治理体系的数据中台实践分享.pptx
- 变压器的铭牌和额定值.pptx
- 计算机网络课程设计报告--用winsock设计Ping应用程序.doc
- 高电压技术课件:第03章 液体和固体介质的电气特性.pdf
- Oracle商务智能精华介绍.pptx
- 基于单片机的输液滴速控制系统设计文档.doc
- dw考试题 5套.pdf
- 学生档案管理系统详细设计说明书.doc
- 操作系统PPT课件.pptx
- 智慧路边停车管理系统方案.pptx
- 【企业内控系列】企业内部控制之人力资源管理控制(17页).doc
- 温度传感器分类与特点.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0