PL/SQL Developer 12.0 User’s Guide - ComponentSource

PL/SQL Developer 12.0 User's Guide

November 2016

PL/SQL Developer 12.0 User's Guide

3

Contents

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

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

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

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.................................................................... 13

4. WRITING PROGRAMS......................................................................................................... 14

4.1

CREATING A PROGRAM...................................................................................................... 14

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.5

TRACKING RUN-TIME ERRORS ........................................................................................... 23

5.6

PACKAGE STATES & JAVA SESSION STATES....................................................................... 23

5.7

VIEWING RESULT SETS ...................................................................................................... 23

5.8

VIEWING DBMS_OUTPUT ................................................................................................... 23

5.9

VIEWING HTP OUTPUT ...................................................................................................... 24

5.10

DEBUGGING ...................................................................................................................... 24

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.2

RESULT GRID MANIPULATION............................................................................................ 38

7.3

QUERY BY EXAMPLE MODE .............................................................................................. 43

7.4

LINKED QUERIES............................................................................................................... 44

7.5

SUBSTITUTION VARIABLES ................................................................................................ 45

7.6

UPDATING THE DATABASE ................................................................................................ 46

7.7

VIEWING AND EDITING XMLTYPE COLUMNS .................................................................. 47

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.1

THE TABLE DEFINITION EDITOR......................................................................................... 56

9.2

THE SEQUENCE DEFINITION EDITOR .................................................................................. 69

9.3

THE SYNONYM DEFINITION EDITOR ................................................................................... 69

9.4

THE LIBRARY DEFINITION EDITOR ..................................................................................... 70

9.5

THE DIRECTORY DEFINITION EDITOR................................................................................. 70

9.6

THE JOB DEFINITION EDITOR ............................................................................................. 71

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

10.4

VIEWING JOB RUNS ........................................................................................................... 85

10.5

VIEWING RUNNING JOBS.................................................................................................... 86

11. DIAGRAMS ............................................................................................................................. 87

11.1

CREATING A DIAGRAM ...................................................................................................... 87

11.2 ZOOMING .......................................................................................................................... 90

11.3

SAVING AND OPENING A DIAGRAM FILE ............................................................................ 90

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

12.7

THE REPORTS MENU........................................................................................................ 106

13. GRAPHICS ............................................................................................................................ 108

14. PROJECTS ............................................................................................................................ 110

14.1

CREATING A NEW PROJECT.............................................................................................. 110

14.2

SAVING A PROJECT .......................................................................................................... 111

14.3

ADDING FILES TO A PROJECT ........................................................................................... 111

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

17.1

THE MAIN CONNECTION .................................................................................................. 122

17.2

WINDOW CONNECTIONS .................................................................................................. 122

17.3

SESSION MODE ................................................................................................................ 123

17.4

EXECUTION IN MULTI SESSION OR DUAL SESSION MODE................................................. 123

18. BROWSING OBJECTS ........................................................................................................ 124

18.1

USING THE OBJECT BROWSER ......................................................................................... 124

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 20.2 20.3 20.4 20.5 20.6 20.7 20.8 20.9 20.10 20.11 20.12 20.13 20.14 20.15 20.16 20.17 20.18 20.19 20.20 20.21 20.22 20.23 20.24 20.25 20.26 20.27 20.28 20.29 20.30 20.31 20.32 20.33

ORACLE ? CONNECTION .................................................................................................. 138 ORACLE ? OPTIONS ......................................................................................................... 139 ORACLE ? COMPILER ...................................................................................................... 141 ORACLE ? DEBUGGER ..................................................................................................... 143 ORACLE ? OUTPUT .......................................................................................................... 144 ORACLE ? TRACE ............................................................................................................ 145 ORACLE ? PROFILER........................................................................................................ 145 ORACLE ? LOGON HISTORY ............................................................................................ 147 ORACLE ? HINTS ............................................................................................................. 148 USER INTERFACE ? OPTIONS ........................................................................................... 150 USER INTERFACE ? OBJECT BROWSER ............................................................................ 152 USER INTERFACE ? EDITOR ............................................................................................. 153 USER INTERFACE ? FONTS............................................................................................... 157 USER INTERFACE ? CODE ASSISTANT ............................................................................. 158 USER INTERFACE ? KEY CONFIGURATION....................................................................... 159 USER INTERFACE ? APPEARANCE.................................................................................... 160 USER INTERFACE ? NLS OPTIONS ................................................................................... 162 WINDOW TYPES ? PROGRAM WINDOW ........................................................................... 163 WINDOW TYPES ? SQL WINDOW.................................................................................... 165 WINDOW TYPES ? TEST WINDOW ................................................................................... 168 WINDOW TYPES ? PLAN WINDOW .................................................................................. 168 TOOLS ? DIFFERENCES .................................................................................................... 169 TOOLS ? DATA GENERATOR............................................................................................ 169 TOOLS ? TO-DO LIST....................................................................................................... 170 TOOLS ? RECALL STATEMENT......................................................................................... 170 FILES ? DIRECTORIES ...................................................................................................... 171 FILES ? EXTENSIONS ....................................................................................................... 173 FILES ? FORMAT.............................................................................................................. 174 FILES ? BACKUP .............................................................................................................. 175 FILES ? HTML/XML....................................................................................................... 176 OTHER ? PRINTING .......................................................................................................... 177 OTHER ? UPDATES & NEWS ............................................................................................ 178 PREFERENCE SETS ........................................................................................................... 179

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download