没有合适的资源?快使用搜索试试~ 我知道了~
PLSQL Developer14用户指南
5星 · 超过95%的资源 需积分: 48 2 下载量 190 浏览量
2022-06-23
11:03:27
上传
评论
收藏 17.81MB PDF 举报
温馨提示
试读
263页
PLSQL Developer14用户指南英文版
资源推荐
资源详情
资源评论
PL/SQL Developer 14.0 User’s
Guide
February 2020
PL/SQL Developer 14.0 User’s Guide 3
Contents
CONTENTS ............................................................................................................................................3
1. INTRODUCTION ..............................................................................................................................9
2. INSTALLATION .............................................................................................................................. 11
2.1 SYSTEM REQUIREMENTS ...............................................................................................................12
2.2 INTERACTIVE INSTALLATION........................................................................................................12
2.3 SILENT INSTALLATION .................................................................................................................12
2.4 UNINSTALLING PL/SQL DEVELOPER ...........................................................................................12
3. LOGGING ON TO AN ORACLE DATABASE .............................................................................12
4. WRITING PROGRAMS .................................................................................................................13
4.1 CREATING A PROGRAM ..................................................................................................................13
4.2 SAVING A PROGRAM .....................................................................................................................15
4.3 MODIFYING A PROGRAM ..............................................................................................................16
4.4 COMPILING A PROGRAM ...............................................................................................................16
4.5 COMPARING A PROGRAM ..............................................................................................................16
4.6 COMPILER PREFERENCES .............................................................................................................17
5. TESTING PROGRAMS ..................................................................................................................18
5.1 CREATING A TEST SCRIPT ..............................................................................................................18
5.2 EXECUTING A TEST SCRIPT ..........................................................................................................19
5.3 VARIABLE TYPES .........................................................................................................................19
5.4 SAVING TEST SCRIPTS ..................................................................................................................20
5.5 TRACKING RUN-TIME ERRORS .....................................................................................................21
5.6 PACKAGE STATES & JAVA SESSION STATES ...................................................................................22
5.7 VIEWING RESULT SETS .................................................................................................................22
5.8 VIEWING DBMS_OUTPUT .............................................................................................................22
5.9 VIEWING HTP OUTPUT ................................................................................................................22
5.10 DEBUGGING ...............................................................................................................................22
5.11 TRACING EXECUTION .................................................................................................................27
5.12 REGRESSION TESTING ................................................................................................................28
5.13 CREATING STANDARD TESTS .....................................................................................................28
6. OPTIMIZING ..................................................................................................................................29
6.1 USING THE EXPLAIN PLAN WINDOW ............................................................................................29
6.2 AUTOMATIC STATISTICS ...............................................................................................................31
6.3 THE PL/SQL PROFILER ...............................................................................................................32
6.4 SQL TRACE .................................................................................................................................33
7. AD HOC SQL ...................................................................................................................................34
7.1 USING THE SQL WINDOW.............................................................................................................34
7.2 RESULT GRID MANIPULATION.......................................................................................................35
7.3 QUERY BY EXAMPLE MODE .........................................................................................................41
7.4 LINKED QUERIES .........................................................................................................................41
7.5 SUBSTITUTION VARIABLES ...........................................................................................................42
7.6 UPDATING THE DATABASE ............................................................................................................43
7.7 VIEWING AND EDITING XMLTYPE COLUMNS .............................................................................44
7.8 COMPARING RECORDS .................................................................................................................44
7.9 COMPARING RESULT SETS ............................................................................................................45
7.10 DIRECT QUERY EXPORT ..............................................................................................................46
7.11 COMMENT DIRECTIVES ................................................................................................................46
7.12 SAVING SQL SCRIPTS ..................................................................................................................47
7.13 CREATING STANDARD QUERIES .................................................................................................48
8. THE COMMAND WINDOW .........................................................................................................48
8.1 ENTERING SQL STATEMENTS AND COMMANDS .............................................................................49
8.2 DEVELOPING COMMAND FILES ................................................................................................... 49
8.3 SUPPORTED COMMANDS ............................................................................................................. 50
8.4 EXPORT TABLES COMMAND SYNTAX .......................................................................................... 53
8.5 EXPORT OBJECTS COMMAND SYNTAX ......................................................................................... 54
9. CREATING AND MODIFYING NON-PL/SQL OBJECTS ....................................................... 54
9.1 THE TABLE DEFINITION EDITOR ................................................................................................... 54
9.2 THE SEQUENCE DEFINITION EDITOR ............................................................................................ 66
9.3 THE SYNONYM DEFINITION EDITOR ............................................................................................ 66
9.4 THE LIBRARY DEFINITION EDITOR ............................................................................................... 67
9.5 THE DIRECTORY DEFINITION EDITOR ........................................................................................... 67
9.6 THE JOB DEFINITION EDITOR ....................................................................................................... 67
9.7 THE QUEUE DEFINITION EDITOR .................................................................................................. 68
9.8 THE QUEUE TABLE DEFINITION EDITOR ....................................................................................... 68
9.9 THE USER DEFINITION EDITOR .................................................................................................... 69
9.10 THE ROLE DEFINITION EDITOR .................................................................................................. 72
9.11 THE PROFILE DEFINITION EDITOR .............................................................................................. 72
9.12 THE DATABASE LINK DEFINITION EDITOR .................................................................................. 73
10. DBMS SCHEDULER .................................................................................................................... 73
10.1 CREATING OBJECTS .................................................................................................................... 79
10.2 EDITING OBJECTS ...................................................................................................................... 79
10.3 DELETING OBJECTS ................................................................................................................... 79
10.4 VIEWING JOB RUNS ................................................................................................................... 79
10.5 VIEWING RUNNING JOBS ........................................................................................................... 80
11. DIAGRAMS ................................................................................................................................... 80
11.1 CREATING A DIAGRAM ................................................................................................................ 81
11.2 ZOOMING .................................................................................................................................. 84
11.3 SAVING AND OPENING A DIAGRAM FILE ..................................................................................... 84
11.4 UPDATING A DIAGRAM .............................................................................................................. 84
11.5 PRINTING A DIAGRAM ............................................................................................................... 84
11.6 EXPORTING A DIAGRAM ............................................................................................................ 84
12. REPORTS ...................................................................................................................................... 85
12.1 STANDARD REPORTS .................................................................................................................. 85
12.2 CUSTOM REPORTS ..................................................................................................................... 85
12.3 VARIABLES ............................................................................................................................... 86
12.4 REFINING THE LAYOUT ............................................................................................................. 90
12.5 THE STYLE LIBRARY ................................................................................................................ 96
12.6 OPTIONS ................................................................................................................................... 96
12.7 THE REPORTS MENU ................................................................................................................. 98
13. GRAPHICS .................................................................................................................................... 99
14. PROJECTS ...................................................................................................................................100
14.1 CREATING A NEW PROJECT ........................................................................................................101
14.2 SAVING A PROJECT ...................................................................................................................102
14.3 ADDING FILES TO A PROJECT ....................................................................................................102
14.4 ADDING DATABASE OBJECTS TO A PROJECT ..............................................................................102
14.5 WORKING WITH PROJECT ITEMS ................................................................................................102
14.6 COMPILING A PROJECT ..............................................................................................................104
15. WORKSETS .................................................................................................................................104
15.1 WORKING WITH WORKSETS ......................................................................................................104
15.2 MANAGING WORKSETS ............................................................................................................106
15.3 WORKSETS & PROJECTS ..........................................................................................................106
15.4 WORKSETS & VERSION CONTROL ...........................................................................................107
PL/SQL Developer 14.0 User’s Guide 5
16. VERSION CONTROL ................................................................................................................. 107
16.1 SETTING UP VERSION CONTROL ................................................................................................. 107
16.2 VERSION CONTROL STATUSES .................................................................................................. 107
16.3 VERSION CONTROL OPERATIONS .............................................................................................. 107
17. TO-DO ITEMS ............................................................................................................................. 108
17.1 CREATING A TO-DO ITEM .......................................................................................................... 109
17.2 EDITING A TO-DO ITEM ........................................................................................................... 110
17.3 CLOSING A TO-DO ITEM .......................................................................................................... 110
17.4 DELETING A TO-DO ITEM ........................................................................................................ 110
18. THE CONNECTION LIST ......................................................................................................... 110
18.1 USING THE CONNECTION LIST .................................................................................................. 110
18.2 DEFINING FOLDERS AND CONNECTIONS ................................................................................... 113
19. CONNECTIONS, WINDOWS, SESSIONS AND TRANSACTIONS ..................................... 115
19.1 THE MAIN CONNECTION ........................................................................................................... 115
19.2 WINDOW CONNECTIONS .......................................................................................................... 116
19.3 SESSION MODE ......................................................................................................................... 116
19.4 EXECUTION IN MULTI SESSION OR DUAL SESSION MODE ......................................................... 117
20. BROWSING OBJECTS .............................................................................................................. 117
20.1 USING THE OBJECT BROWSER ................................................................................................... 117
20.2 OBJECT BROWSER FILTERS ...................................................................................................... 124
20.3 OBJECT BROWSER FOLDERS .................................................................................................... 125
21. BROWSING FILES ..................................................................................................................... 126
21.1 SETTING UP THE FILE BROWSER ............................................................................................... 127
21.2 USING THE FILE BROWSER ...................................................................................................... 128
21.3 FILTERS.................................................................................................................................... 129
22. PREFERENCES........................................................................................................................... 129
22.1 ORACLE – CONNECTION ........................................................................................................... 131
22.2 ORACLE – OPTIONS ................................................................................................................. 132
22.3 ORACLE – COMPILER ............................................................................................................... 134
22.4 ORACLE – DEBUGGER.............................................................................................................. 135
22.5 ORACLE – OUTPUT .................................................................................................................. 137
22.6 ORACLE – TRACE..................................................................................................................... 137
22.7 ORACLE – PROFILER ................................................................................................................ 138
22.8 ORACLE – LOGON HISTORY ..................................................................................................... 139
22.9 ORACLE – HINTS ..................................................................................................................... 140
22.10 USER INTERFACE – OPTIONS .................................................................................................. 141
22.11 USER INTERFACE – OBJECT BROWSER ................................................................................... 143
22.12 USER INTERFACE – EDITOR .................................................................................................... 144
22.13 USER INTERFACE – FONTS ..................................................................................................... 148
22.14 USER INTERFACE – CODE ASSISTANT .................................................................................... 149
22.15 USER INTERFACE – KEY CONFIGURATION .............................................................................. 150
22.16 USER INTERFACE – APPEARANCE............................................................................................ 151
22.17 USER INTERFACE – NLS OPTIONS ........................................................................................... 153
22.18 WINDOW TYPES – GENERAL ................................................................................................... 154
22.19 WINDOW TYPES – PROGRAM WINDOW ................................................................................... 154
22.20 WINDOW TYPES – SQL WINDOW .......................................................................................... 156
22.21 WINDOW TYPES – TEST WINDOW .......................................................................................... 159
22.22 WINDOW TYPES – PLAN WINDOW ......................................................................................... 159
22.23 TOOLS – DIFFERENCE VIEWER .............................................................................................. 160
22.24 TOOLS – DATA GENERATOR ................................................................................................... 161
22.25 TOOLS – TO-DO LIST ............................................................................................................. 161
22.26 TOOLS – RECALL STATEMENT ................................................................................................ 162
剩余262页未读,继续阅读
awsbamboo115
- 粉丝: 30
- 资源: 164
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
前往页