没有合适的资源?快使用搜索试试~ 我知道了~
资源详情
资源评论
PL/SQL Developer 7.0
User’s Guide
January 2006
PL/SQL Developer 7.0 User’s Guide 3
Contents
CONTENTS..............................................................................................................................................................3
1. INTRODUCTION......................................................................................................................................9
2. INSTALLATION.....................................................................................................................................13
2.1 SYSTEM REQUIREMENTS..................................................................................................................13
2.2 WORKSTATION INSTALLATION.......................................................................................................13
2.3 SERVER BASED INSTALLATION.......................................................................................................13
2.4 SCRIPTED INSTALLATION.................................................................................................................14
2.5 UNINSTALLING PL/SQL DEVELOPER............................................................................................14
3. WRITING PROGRAMS........................................................................................................................15
3.1 CREATING A PROGRAM ....................................................................................................................15
3.2 SAVING A PROGRAM .........................................................................................................................16
3.3 MODIFYING A PROGRAM..................................................................................................................17
3.4 COMPILING A PROGRAM...................................................................................................................17
3.5 SUBSTITUTION VARIABLES..............................................................................................................18
4. TESTING PROGRAMS.........................................................................................................................19
4.1 CREATING A TEST SCRIPT ...............................................................................................................19
4.2 EXECUTING A TEST SCRIPT .............................................................................................................20
4.3 VARIABLE TYPES...............................................................................................................................21
4.4 SAVING TEST SCRIPTS......................................................................................................................22
4.5 TRACKING RUN-TIME ERRORS.........................................................................................................23
4.6 PACKAGE STATES & JAVA SESSION STATES.................................................................................23
4.7 VIEWING RESULT SETS.....................................................................................................................23
4.8 VIEWING DBMS_OUTPUT .................................................................................................................23
4.9 VIEWING HTP OUTPUT ....................................................................................................................24
4.10 DEBUGGING........................................................................................................................................24
4.11 TRACING EXECUTION .......................................................................................................................27
4.12 REGRESSION TESTING.......................................................................................................................28
5. OPTIMIZING............................................................................................................................................29
5.1 USING THE EXPLAIN PLAN WINDOW .............................................................................................29
5.2 AUTOMATIC STATISTICS...................................................................................................................30
5.3 THE PL/SQL PROFILER....................................................................................................................31
5.4 SQL TRACE ........................................................................................................................................32
6. AD HOC SQL............................................................................................................................................34
6.1 USING THE SQL WINDOW...............................................................................................................34
6.2 RESULT GRID MANIPULATION .........................................................................................................35
6.3 QUERY BY EXAMPLE MODE ............................................................................................................39
6.4 LINKED QUERIES...............................................................................................................................40
6.5 SUBSTITUTION VARIABLES..............................................................................................................40
6.6 UPDATING THE DATABASE ..............................................................................................................41
6.7 VIEWING AND EDITING XMLTYPE COLUMNS.............................................................................42
6.8 DIRECT QUERY EXPORT ..................................................................................................................42
6.9 SAVING SQL SCRIPTS......................................................................................................................42
6.10 CREATING STANDARD QUERIES.....................................................................................................43
7. THE COMMAND WINDOW...............................................................................................................44
7.1 ENTERING SQL STATEMENTS AND COMMANDS..........................................................................44
7.2 DEVELOPING COMMAND FILES........................................................................................................45
7.3 SUPPORTED COMMANDS..................................................................................................................46
4 PL/SQL Developer 7.0 User’s Guide
8. CREATING AND MODIFYING NON-PL/SQL OBJECTS ......................................................49
8.1 THE TABLE DEFINITION EDITOR......................................................................................................49
8.2 THE SEQUENCE DEFINITION EDITOR ..............................................................................................60
8.3 THE SYNONYM DEFINITION EDITOR...............................................................................................60
8.4 THE LIBRARY DEFINITION EDITOR .................................................................................................61
8.5 THE DIRECTORY DEFINITION EDITOR.............................................................................................61
8.6 THE JOB DEFINITION EDITOR...........................................................................................................62
8.7 THE QUEUE DEFINITION EDITOR.....................................................................................................62
8.8 THE QUEUE TABLE DEFINITION EDITOR ........................................................................................63
8.9 THE USER DEFINITION EDITOR........................................................................................................64
8.10 THE ROLE DEFINITION EDITOR........................................................................................................67
8.11 THE PROFILE DEFINITION EDITOR...................................................................................................68
8.12 THE DATABASE LINK DEFINITION EDITOR ....................................................................................68
9. DIAGRAMS ..............................................................................................................................................69
9.1 CREATING A DIAGRAM.....................................................................................................................69
9.2 SAVING AND OPENING A DIAGRAM FILE .......................................................................................71
9.3 UPDATING A DIAGRAM ....................................................................................................................71
10. REPORTS..................................................................................................................................................72
10.1 STANDARD REPORTS........................................................................................................................72
10.2 CUSTOM REPORTS.............................................................................................................................73
10.3 VARIABLES.........................................................................................................................................74
10.4 REFINING THE LAYOUT ....................................................................................................................77
10.5 THE STYLE LIBRARY........................................................................................................................84
10.6 OPTIONS.............................................................................................................................................84
10.7 THE REPORTS MENU.........................................................................................................................86
11. GRAPHICS ...............................................................................................................................................87
12. PROJECTS................................................................................................................................................89
12.1 CREATING A NEW PROJECT .............................................................................................................89
12.2 SAVING A PROJECT ...........................................................................................................................89
12.3 ADDING FILES TO A PROJECT ..........................................................................................................90
12.4 ADDING DATABASE OBJECTS TO A PROJECT ................................................................................90
12.5 WORKING WITH PROJECT ITEMS.....................................................................................................90
12.6 COMPILING A PROJECT .....................................................................................................................91
13. TO-DO ITEMS .........................................................................................................................................92
13.1 CREATING A TO-DO ITEM ...............................................................................................................93
13.2 EDITING A TO-DO ITEM...................................................................................................................93
13.3 CLOSING A TO-DO ITEM..................................................................................................................94
13.4 DELETING A TO-DO ITEM................................................................................................................94
14. WINDOWS, DATABASE SESSIONS AND TRANSACTIONS................................................95
14.1 SESSION MODE ..................................................................................................................................95
14.2 EXECUTION IN MULTI SESSION OR DUAL SESSION MODE..........................................................95
15. BROWSING OBJECTS.........................................................................................................................96
15.1 USING THE BROWSER.......................................................................................................................96
15.2 BROWSER FILTERS..........................................................................................................................101
15.3 BROWSER FOLDERS........................................................................................................................102
16. PREFERENCES ....................................................................................................................................104
16.1 ORACLE – CONNECTION................................................................................................................105
16.2 ORACLE – OPTIONS........................................................................................................................106
16.3 ORACLE – DEBUGGER....................................................................................................................107
PL/SQL Developer 7.0 User’s Guide 5
16.4 ORACLE – OUTPUT ........................................................................................................................ 108
16.5 ORACLE – TRACE ...........................................................................................................................109
16.6 ORACLE – PROFILER......................................................................................................................109
16.7 ORACLE – LOGON HISTORY.........................................................................................................110
16.8 ORACLE – HINTS............................................................................................................................111
16.9 USER INTERFACE – OPTIONS........................................................................................................113
16.10 USER INTERFACE – TOOLBAR......................................................................................................114
16.11 USER INTERFACE – BROWSER......................................................................................................114
16.12 USER INTERFACE – EDITOR..........................................................................................................115
16.13 USER INTERFACE – FONTS............................................................................................................117
16.14 USER INTERFACE – CODE ASSISTANT ........................................................................................118
16.15 USER INTERFACE – KEY CONFIGURATION................................................................................119
16.16 USER INTERFACE – APPEARANCE ...............................................................................................120
16.17 USER INTERFACE – DATE/TIME ..................................................................................................121
16.18 WINDOW TYPES – PROGRAM WINDOW .....................................................................................122
16.19 WINDOW TYPES – SQL WINDOW ...............................................................................................124
16.20 WINDOW TYPES – TEST WINDOW ..............................................................................................126
16.21 WINDOW TYPES – PLAN WINDOW ..............................................................................................126
16.22 TOOLS – DIFFERENCES..................................................................................................................126
16.23 TOOLS – DATA GENERATOR........................................................................................................127
16.24 TOOLS – TO-DO LIST .....................................................................................................................128
16.25 TOOLS – RECALL STATEMENT ....................................................................................................128
16.26 FILES – DIRECTORIES....................................................................................................................129
16.27 FILES – EXTENSIONS......................................................................................................................130
16.28 FILES – FORMAT .............................................................................................................................131
16.29 FILES – BACKUP .............................................................................................................................131
16.30 FILES – HTML/XML.....................................................................................................................132
16.31 OTHER – PRINTING........................................................................................................................133
16.32 OTHER – UPDATES & NEWS.........................................................................................................134
16.33 PREFERENCE SETS..........................................................................................................................135
17. TOOLS......................................................................................................................................................137
17.1 BROWSER.........................................................................................................................................137
17.2 FIND DATABASE OBJECTS............................................................................................................137
17.3 COMPILE INVALID OBJECTS.........................................................................................................138
17.4 EXPORT TABLES.............................................................................................................................139
17.5 IMPORT TABLES..............................................................................................................................142
17.6 EXPORT USER OBJECTS.................................................................................................................144
17.7 TEXT IMPORTER.............................................................................................................................145
17.8 ODBC IMPORTER..........................................................................................................................148
17.9 DATA GENERATOR ........................................................................................................................150
17.10 COMPARE USER OBJECTS.............................................................................................................153
17.11 COMPARE TABLE DATA................................................................................................................155
17.12 EVENT MONITOR............................................................................................................................157
17.13 SESSIONS..........................................................................................................................................158
17.14 USER DEFINED TOOLS...................................................................................................................160
17.15 TEST MANAGER..............................................................................................................................164
18. THE EDITOR.........................................................................................................................................167
18.1 SELECTION FUNCTIONS.................................................................................................................167
18.2 COLUMN SELECTION......................................................................................................................167
18.3 GUIDELINES.....................................................................................................................................168
18.4 CODE ASSISTANT ...........................................................................................................................168
18.5 RECALLING STATEMENTS.............................................................................................................169
剩余216页未读,继续阅读
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论3
最新资源