Transcription
PL/SQL Developer 13.0User’s GuideDecember 2018
PL/SQL Developer 13.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 . 447.4LINKED QUERIES . 457.5SUBSTITUTION VARIABLES . 467.6UPDATING THE DATABASE . 477.7VIEWING AND EDITING XMLTYPE COLUMNS . 487.8COMPARING RECORDS . 487.9DIRECT QUERY EXPORT . 497.10COMMENT DIRECTIVES . 497.11SAVING SQL SCRIPTS . 507.12CREATING STANDARD QUERIES . 504.14.24.34.44.54.6
4PL/SQL Developer 13.0 User’s Guide8.THE COMMAND WINDOW . 52ENTERING SQL STATEMENTS AND COMMANDS . 52DEVELOPING COMMAND FILES . 53SUPPORTED COMMANDS. 539.CREATING AND MODIFYING NON-PL/SQL OBJECTS. 579.1THE TABLE DEFINITION EDITOR . 579.2THE SEQUENCE DEFINITION EDITOR . 709.3THE SYNONYM DEFINITION EDITOR . 709.4THE LIBRARY DEFINITION EDITOR . 719.5THE DIRECTORY DEFINITION EDITOR . 719.6THE JOB DEFINITION EDITOR . 729.7THE QUEUE DEFINITION EDITOR . 729.8THE QUEUE TABLE DEFINITION EDITOR . 739.9THE USER DEFINITION EDITOR . 749.10THE ROLE DEFINITION EDITOR . 779.11THE PROFILE DEFINITION EDITOR . 779.12THE DATABASE LINK DEFINITION EDITOR. 7810.DBMS SCHEDULER . 7910.1CREATING OBJECTS . 8610.2EDITING OBJECTS . 8610.3DELETING OBJECTS . 8610.4VIEWING JOB RUNS . 8610.5VIEWING RUNNING JOBS. 8711.DIAGRAMS . 8811.1CREATING A DIAGRAM . 8811.2ZOOMING . 9111.3SAVING AND OPENING A DIAGRAM FILE . 9111.4UPDATING A DIAGRAM . 9111.5PRINTING A DIAGRAM . 9211.6EXPORTING A DIAGRAM . 9212.REPORTS . 9312.1STANDARD REPORTS . 9312.2CUSTOM REPORTS . 9412.3VARIABLES . 9412.4REFINING THE LAYOUT. 9912.5THE STYLE LIBRARY . 10512.6OPTIONS . 10612.7THE REPORTS MENU . 10713.GRAPHICS . 1098.18.28.314.PROJECTS . 11114.1CREATING A NEW PROJECT . 11114.2SAVING A PROJECT . 11214.3ADDING FILES TO A PROJECT . 11214.4ADDING DATABASE OBJECTS TO A PROJECT . 11214.5WORKING WITH PROJECT ITEMS . 11314.6COMPILING A PROJECT . 11415.TO-DO ITEMS . 11515.1CREATING A TO-DO ITEM . 11615.2EDITING A TO-DO ITEM. 11615.3CLOSING A TO-DO ITEM. 116
PL/SQL Developer 13.0 User’s Guide515.4DELETING A TO-DO ITEM . 11616.THE CONNECTION LIST . 11716.1USING THE CONNECTION LIST . 11716.2DEFINING FOLDERS AND CONNECTIONS . 12017.CONNECTIONS, WINDOWS, SESSIONS AND TRANSACTIONS . 12317.1THE MAIN CONNECTION . 12317.2WINDOW CONNECTIONS . 12317.3SESSION MODE . 12417.4EXECUTION IN MULTI SESSION OR DUAL SESSION MODE. 12418.BROWSING OBJECTS . 12518.1USING THE OBJECT BROWSER . 12518.2OBJECT BROWSER FILTERS . 13218.3OBJECT BROWSER FOLDERS. 13319.BROWSING FILES. 13519.1SETTING UP THE FILE BROWSER . 13619.2USING THE FILE BROWSER . 13720.PREFERENCES . 13820.1ORACLE – CONNECTION . 13920.2ORACLE – OPTIONS . 14020.3ORACLE – COMPILER . 14220.4ORACLE – DEBUGGER . 14420.5ORACLE – OUTPUT . 14520.6ORACLE – TRACE . 14620.7ORACLE – PROFILER . 14720.8ORACLE – LOGON HISTORY . 14820.9ORACLE – HINTS . 14920.10USER INTERFACE – OPTIONS . 15120.11USER INTERFACE – OBJECT BROWSER . 15320.12USER INTERFACE – EDITOR . 15420.13USER INTERFACE – FONTS. 15820.14USER INTERFACE – CODE ASSISTANT . 15920.15USER INTERFACE – KEY CONFIGURATION. 16120.16USER INTERFACE – APPEARANCE . 16120.17USER INTERFACE – NLS OPTIONS . 16320.18WINDOW TYPES – GENERAL . 16420.19WINDOW TYPES – PROGRAM WINDOW . 16520.20WINDOW TYPES – SQL WINDOW . 16720.21WINDOW TYPES – TEST WINDOW . 17020.22WINDOW TYPES – PLAN WINDOW . 17020.23TOOLS – DIFFERENCES . 17120.24TOOLS – DATA GENERATOR. 17120.25TOOLS – TO-DO LIST. 17220.26TOOLS – RECALL STATEMENT . 17220.27FILES – DIRECTORIES . 17320.28FILES – EXTENSIONS . 17520.29FILES – FORMAT . 17620.30FILES – BACKUP . 17720.31FILES – HTML/XML. 17820.32OTHER – PRINTING . 17920.33OTHER – UPDATES & NEWS . 18020.34PREFERENCE SETS . 181
6PL/SQL Developer 13.0 User’s Guide21.TOOLS . 18321.1OBJECT BROWSER . 18321.2FIND DATABASE OBJECTS . 18321.3COMPILE INVALID OBJECTS . 18421.4EXPORT TABLES. 18521.5IMPORT TABLES . 18821.6EXPORT USER OBJECTS. 19021.7TEXT IMPORTER . 19121.8ODBC IMPORTER . 19421.9DATA GEN
PL/SQL Developer 13.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
