Transcription
PL/SQL Developer 12.0User’s GuideNovember 2016
PL/SQL Developer 12.0 User’s Guide3ContentsCONTENTS . 31.INTRODUCTION. 92.2.12.22.32.43.4.INSTALLATION . 12SYSTEM REQUIREMENTS. 12INTERACTIVE INSTALLATION. 12SILENT INSTALLATION. 12UNINSTALLING PL/SQL DEVELOPER . 12LOGGING ON TO AN ORACLE DATABASE. 13WRITING PROGRAMS . 14CREATING A PROGRAM . 14SAVING A PROGRAM . 15MODIFYING A PROGRAM . 16COMPILING A PROGRAM . 16COMPARING A PROGRAM . 17COMPILER PREFERENCES . 185.TESTING PROGRAMS. 195.1CREATING A TEST SCRIPT . 195.2EXECUTING A TEST SCRIPT . 205.3VARIABLE TYPES . 215.4SAVING TEST SCRIPTS . 225.5TRACKING RUN-TIME ERRORS . 235.6PACKAGE STATES & JAVA SESSION STATES . 235.7VIEWING RESULT SETS . 235.8VIEWING DBMS OUTPUT . 235.9VIEWING HTP OUTPUT . 245.10DEBUGGING . 245.11TRACING EXECUTION . 295.12REGRESSION TESTING . 305.13CREATING STANDARD TESTS . 306.OPTIMIZING . 316.1USING THE EXPLAIN PLAN WINDOW . 316.2AUTOMATIC STATISTICS . 336.3THE PL/SQL PROFILER . 346.4SQL TRACE . 347.AD HOC SQL. 367.1USING THE SQL WINDOW . 367.2RESULT GRID MANIPULATION. 387.3QUERY BY EXAMPLE MODE . 437.4LINKED QUERIES . 447.5SUBSTITUTION VARIABLES . 457.6UPDATING THE DATABASE . 467.7VIEWING AND EDITING XMLTYPE COLUMNS . 477.8COMPARING RECORDS . 477.9DIRECT QUERY EXPORT . 487.10COMMENT DIRECTIVES . 487.11SAVING SQL SCRIPTS . 497.12CREATING STANDARD QUERIES . 494.14.24.34.44.54.6
4PL/SQL Developer 12.0 User’s Guide8.THE COMMAND WINDOW . 51ENTERING SQL STATEMENTS AND COMMANDS . 51DEVELOPING COMMAND FILES . 52SUPPORTED COMMANDS. 529.CREATING AND MODIFYING NON-PL/SQL OBJECTS. 569.1THE TABLE DEFINITION EDITOR . 569.2THE SEQUENCE DEFINITION EDITOR . 699.3THE SYNONYM DEFINITION EDITOR . 699.4THE LIBRARY DEFINITION EDITOR . 709.5THE DIRECTORY DEFINITION EDITOR . 709.6THE JOB DEFINITION EDITOR . 719.7THE QUEUE DEFINITION EDITOR . 719.8THE QUEUE TABLE DEFINITION EDITOR . 729.9THE USER DEFINITION EDITOR . 739.10THE ROLE DEFINITION EDITOR . 769.11THE PROFILE DEFINITION EDITOR . 769.12THE DATABASE LINK DEFINITION EDITOR. 7710.DBMS SCHEDULER . 7810.1CREATING OBJECTS . 8510.2EDITING OBJECTS . 8510.3DELETING OBJECTS . 8510.4VIEWING JOB RUNS . 8510.5VIEWING RUNNING JOBS. 8611.DIAGRAMS . 8711.1CREATING A DIAGRAM . 8711.2ZOOMING . 9011.3SAVING AND OPENING A DIAGRAM FILE . 9011.4UPDATING A DIAGRAM . 9011.5PRINTING A DIAGRAM . 9111.6EXPORTING A DIAGRAM . 9112.REPORTS . 9212.1STANDARD REPORTS . 9212.2CUSTOM REPORTS . 9312.3VARIABLES . 9312.4REFINING THE LAYOUT. 9812.5THE STYLE LIBRARY . 10412.6OPTIONS . 10512.7THE REPORTS MENU . 10613.GRAPHICS . 1088.18.28.314.PROJECTS . 11014.1CREATING A NEW PROJECT . 11014.2SAVING A PROJECT . 11114.3ADDING FILES TO A PROJECT . 11114.4ADDING DATABASE OBJECTS TO A PROJECT . 11114.5WORKING WITH PROJECT ITEMS . 11214.6COMPILING A PROJECT . 11315.TO-DO ITEMS . 11415.1CREATING A TO-DO ITEM . 11515.2EDITING A TO-DO ITEM. 11515.3CLOSING A TO-DO ITEM. 115
PL/SQL Developer 12.0 User’s Guide515.4DELETING A TO-DO ITEM . 11516.THE CONNECTION LIST . 11616.1USING THE CONNECTION LIST . 11616.2DEFINING FOLDERS AND CONNECTIONS . 11917.CONNECTIONS, WINDOWS, SESSIONS AND TRANSACTIONS . 12217.1THE MAIN CONNECTION . 12217.2WINDOW CONNECTIONS . 12217.3SESSION MODE . 12317.4EXECUTION IN MULTI SESSION OR DUAL SESSION MODE. 12318.BROWSING OBJECTS . 12418.1USING THE OBJECT BROWSER . 12418.2OBJECT BROWSER FILTERS . 13118.3OBJECT BROWSER FOLDERS. 13219.BROWSING FILES. 13419.1SETTING UP THE FILE BROWSER . 13519.2USING THE FILE BROWSER . 13620.PREFERENCES . 13720.1ORACLE – CONNECTION . 13820.2ORACLE – OPTIONS . 13920.3ORACLE – COMPILER . 14120.4ORACLE – DEBUGGER . 14320.5ORACLE – OUTPUT . 14420.6ORACLE – TRACE . 14520.7ORACLE – PROFILER . 14520.8ORACLE – LOGON HISTORY . 14720.9ORACLE – HINTS . 14820.10USER INTERFACE – OPTIONS . 15020.11USER INTERFACE – OBJECT BROWSER . 15220.12USER INTERFACE – EDITOR . 15320.13USER INTERFACE – FONTS. 15720.14USER INTERFACE – CODE ASSISTANT . 15820.15USER INTERFACE – KEY CONFIGURATION. 15920.16USER INTERFACE – APPEARANCE . 16020.17USER INTERFACE – NLS OPTIONS . 16220.18WINDOW TYPES – PROGRAM WINDOW . 16320.19WINDOW TYPES – SQL WINDOW . 16520.20WINDOW TYPES – TEST WINDOW . 16820.21WINDOW TYPES – PLAN WINDOW . 16820.22TOOLS – DIFFERENCES . 16920.23TOOLS – DATA GENERATOR. 16920.24TOOLS – TO-DO LIST. 17020.25TOOLS – RECALL STATEMENT . 17020.26FILES – DIRECTORIES . 17120.27FILES – EXTENSIONS . 17320.28FILES – FORMAT . 17420.29FILES – BACKUP . 17520.30FILES – HTML/XML. 17620.31OTHER – PRINTING . 17720.32OTHER – UPDATES & NEWS . 17820.33PREFERENCE SETS . 179
6PL/SQL Developer 12.0 User’s Guide21.TOOLS . 18121.1OBJECT BROWSER . 18121.2FIND DATABASE OBJECTS . 18121.3COMPILE INVALID OBJECTS . 18221.4EXPORT TABLES. 18321.5IMPORT TABLES . 18621.6EXPORT USER OBJECTS. 18821.7TEXT IMPORTER . 18921.8ODBC IMPORTER . 19221.9DATA GENERATOR . 19421.10C
PL/SQL Developer 12.0 User’s Guide 9 1. Introduction PL/SQL Developer is an Integrated Development Environment (IDE) for developing stored program units in an Oracle Database. Using PL/SQL Developer you can conveniently c
