Oracle PL/SQL帮助文档（英文版）

PL/SQL Developer 12.0

User’s Guide

July 2017

PL/SQL Developer 12.0 User’s Guide 3

Contents

CONTENTS ........................................................................................................................................... 3

1. INTRODUCTION...................................................................................................................... 9

2. INSTALLATION..................................................................................................................... 12

2.1 SYSTEM REQUIREMENTS.................................................................................................... 12

4.2 SAVING A PROGRAM.......................................................................................................... 15

4.3 MODIFYING A PROGRAM ................................................................................................... 16

4.4 COMPILING A PROGRAM .................................................................................................... 16

4.5 COMPARING A PROGRAM................................................................................................... 17

4.6 COMPILER PREFERENCES................................................................................................... 18

5. TESTING PROGRAMS.......................................................................................................... 19

5.1 CREATING A TEST SCRIPT ................................................................................................. 19

5.2 EXECUTING A TEST SCRIPT ............................................................................................... 20

5.3 VARIABLE TYPES............................................................................................................... 21

5.4 SAVING TEST SCRIPTS ....................................................................................................... 22

5.11 TRACING EXECUTION ........................................................................................................ 29

5.12 REGRESSION TESTING........................................................................................................ 30

5.13 CREATING STANDARD TESTS ............................................................................................ 30

6. OPTIMIZING .......................................................................................................................... 31

6.1 USING THE EXPLAIN PLAN WINDOW................................................................................. 31

6.2 AUTOMATIC STATISTICS.................................................................................................... 33

6.3 THE PL/SQL PROFILER ..................................................................................................... 34

6.4 SQL TRACE....................................................................................................................... 34

7. AD HOC SQL........................................................................................................................... 36

7.1 USING THE SQL WINDOW ................................................................................................. 36

7.8 COMPARING RECORDS....................................................................................................... 47

7.9 DIRECT QUERY EXPORT .................................................................................................... 48

7.10 COMMENT DIRECTIVES...................................................................................................... 48

7.11 SAVING SQL SCRIPTS ....................................................................................................... 49

7.12 CREATING STANDARD QUERIES ........................................................................................ 49

4 PL/SQL Developer 12.0 User’s Guide

8. THE COMMAND WINDOW................................................................................................. 51

8.1 ENTERING SQL STATEMENTS AND COMMANDS ................................................................ 51

8.2 DEVELOPING COMMAND FILES .......................................................................................... 52

8.3 SUPPORTED COMMANDS.................................................................................................... 52

9. CREATING AND MODIFYING NON-PL/SQL OBJECTS................................................ 56

9.7 THE QUEUE DEFINITION EDITOR ........................................................................................ 71

9.8 THE QUEUE TABLE DEFINITION EDITOR ............................................................................. 72

9.9 THE USER DEFINITION EDITOR ........................................................................................... 73

9.10 THE ROLE DEFINITION EDITOR........................................................................................... 76

9.11 THE PROFILE DEFINITION EDITOR ...................................................................................... 76

9.12 THE DATABASE LINK DEFINITION EDITOR.......................................................................... 77

10. DBMS SCHEDULER .............................................................................................................. 78

10.1 CREATING OBJECTS ........................................................................................................... 85

10.2 EDITING OBJECTS .............................................................................................................. 85

10.3 DELETING OBJECTS ........................................................................................................... 85

11.4 UPDATING A DIAGRAM ...................................................................................................... 90

11.5 PRINTING A DIAGRAM ....................................................................................................... 91

11.6 EXPORTING A DIAGRAM .................................................................................................... 91

12. REPORTS ................................................................................................................................ 92

12.1 STANDARD REPORTS ......................................................................................................... 92

12.2 CUSTOM REPORTS ............................................................................................................. 93

12.3 VARIABLES ....................................................................................................................... 93

12.4 REFINING THE LAYOUT...................................................................................................... 98

12.5 THE STYLE LIBRARY....................................................................................................... 104

12.6 OPTIONS.......................................................................................................................... 105

14.4 ADDING DATABASE OBJECTS TO A PROJECT .................................................................... 111

14.5 WORKING WITH PROJECT ITEMS ...................................................................................... 112

14.6 COMPILING A PROJECT .................................................................................................... 113

15. TO-DO ITEMS ...................................................................................................................... 114

15.1 CREATING A TO-DO ITEM ............................................................................................... 115

15.2 EDITING A TO-DO ITEM................................................................................................... 115

15.3 CLOSING A TO-DO ITEM.................................................................................................. 115

PL/SQL Developer 12.0 User’s Guide 5

15.4 DELETING A TO-DO ITEM................................................................................................ 115

16. THE CONNECTION LIST................................................................................................... 116

16.1 USING THE CONNECTION LIST......................................................................................... 116

16.2 DEFINING FOLDERS AND CONNECTIONS .......................................................................... 119

17. CONNECTIONS, WINDOWS, SESSIONS AND TRANSACTIONS ............................... 122

18.2 OBJECT BROWSER FILTERS ............................................................................................. 131

18.3 OBJECT BROWSER FOLDERS............................................................................................ 132

19. BROWSING FILES............................................................................................................... 134

19.1 SETTING UP THE FILE BROWSER...................................................................................... 135

19.2 USING THE FILE BROWSER .............................................................................................. 136

20. PREFERENCES .................................................................................................................... 137

20.1 ORACLE – CONNECTION.................................................................................................. 138

20.2 ORACLE – OPTIONS ......................................................................................................... 139

20.3 ORACLE – COMPILER ...................................................................................................... 141

20.4 ORACLE – DEBUGGER ..................................................................................................... 143

20.11 USER INTERFACE – OBJECT BROWSER ............................................................................ 152

20.12 USER INTERFACE – EDITOR ............................................................................................. 153

20.13 USER INTERFACE – FONTS............................................................................................... 157

20.14 USER INTERFACE – CODE ASSISTANT ............................................................................. 158

20.15 USER INTERFACE – KEY CONFIGURATION....................................................................... 159

20.16 USER INTERFACE – APPEARANCE.................................................................................... 160

20.17 USER INTERFACE – NLS OPTIONS ................................................................................... 162

20.18 WINDOW TYPES – PROGRAM WINDOW ........................................................................... 163

20.19 WINDOW TYPES – SQL WINDOW.................................................................................... 165

20.20 WINDOW TYPES – TEST WINDOW ................................................................................... 168

20.27 FILES – EXTENSIONS ....................................................................................................... 173

20.28 FILES – FORMAT.............................................................................................................. 174

20.29 FILES – BACKUP .............................................................................................................. 175

20.30 FILES – HTML/XML....................................................................................................... 176

20.31 OTHER – PRINTING .......................................................................................................... 177

20.32 OTHER – UPDATES & NEWS ............................................................................................ 178

20.33 PREFERENCE SETS ........................................................................................................... 179