PL/SQL Developer 7.1
User’s Guide
March 2007
PL/SQL Developer 7.1 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.1 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.1 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 ...............................................................................................115
16.11 USER INTERFACE – BROWSER...............................................................................................115
16.12 USER INTERFACE – EDITOR................................................................................................... 117
16.13 USER INTERFACE – FONTS..................................................................................................... 120
16.14 USER INTERFACE – CODE ASSISTANT ..................................................................................121
16.15 USER INTERFACE – KEY CONFIGURATION ...........................................................................122
16.16 USER INTERFACE – APPEARANCE .........................................................................................123
16.17 USER INTERFACE – DATE/TIME ............................................................................................124
16.18 WINDOW TYPES – PROGRAM WINDOW................................................................................125
16.19 WINDOW TYPES – SQL WINDOW .........................................................................................127
16.20 WINDOW TYPES – TEST WINDOW ........................................................................................129
16.21 WINDOW TYPES – PLAN WINDOW........................................................................................129
16.22 TOOLS – DIFFERENCES ..........................................................................................................129
16.23 TOOLS – DATA GENERATOR ................................................................................................. 130
16.24 TOOLS – TO-DO LIST .............................................................................................................131
16.25 TOOLS – RECALL STATEMENT ..............................................................................................131
16.26 FILES – DIRECTORIES.............................................................................................................132
16.27 FILES – EXTENSIONS..............................................................................................................133
16.28 FILES – FORMAT.....................................................................................................................134
16.29 FILES – BACKUP .....................................................................................................................134
16.30 FILES – HTML/XML .............................................................................................................135
16.31 OTHER – PRINTING.................................................................................................................136
16.32 OTHER – UPDATES & NEWS .................................................................................................. 137
16.33 PREFERENCE SETS..................................................................................................................138
17. TOOLS............................................................................................................................................140
17.1 BROWSER................................................................................................................................140
17.2 FIND DATABASE OBJECTS ..................................................................................................... 140
17.3 COMPILE INVALID OBJECTS .................................................................................................. 141
17.4 EXPORT TABLES.....................................................................................................................142
17.5 IMPORT TABLES .....................................................................................................................145
17.6 EXPORT USER OBJECTS .........................................................................................................147
17.7 TEXT IMPORTER .....................................................................................................................148
17.8 ODBC IMPORTER...................................................................................................................151
17.9 DATA GENERATOR.................................................................................................................153
17.10 COMPARE USER OBJECTS ...................................................................................................... 156
17.11 COMPARE TABLE DATA.........................................................................................................158
17.12 EVENT MONITOR....................................................................................................................160
17.13 SESSIONS ................................................................................................................................161
17.14 USER DEFINED TOOLS ...........................................................................................................163
17.15 TEST MANAGER .....................................................................................................................167
18. THE EDITOR ................................................................................................................................170
18.1 SELECTION FUNCTIONS..........................................................................................................170
18.2 COLUMN SELECTION ..............................................................................................................170
18.3 CODE ASSISTANT ...................................................................................................................171
18.4 RECALLING STATEMENTS ......................................................................................................172
18.5 SPECIAL COPY ........................................................................................................................172
评论24
最新资源