PL/SQL Developer

PL/SQL Developer (Allround Automations)

Multi-threaded integrated development environment for developing, testing, debugging and optimising Oracle PL/SQL stored program units such as packages and triggers.An optional Annual Service Contract is available.

Licences

Please login to view pricing

Overview

PL/SQL Developer is an Integrated Development Environment that is specifically targeted at the development of stored program units for Oracle Databases. Over time we have seen more and more business logic and application logic move into the Oracle Server, so that PL/SQL programming has become a significant part of the total development process. PL/SQL Developer focuses on ease of use, code quality and productivity, key advantages during Oracle application development.

Key Features:

  • NEW Ribbon User Interface: PL/SQL Developer now uses a new Ribbon User Interface instead of a Menu User Interface; The Quick Access Toolbar above the ribbon contains the most frequently used functions.
  • NEW Single Document Interface: On the "View" ribbon you can now choose between a Single Document Interface (SDI) or Multiple Document Interface
  • NEW PL/SQL Clipboard: The new PL/SQL Clipboard is a dockable tool that stores the history of all SQL and PL/SQL code you copy to the Windows clipboard, so that you can paste the clipboard item again in the future. It has a filter function so that you can quickly find a clipboard item based on its contents:
  • NEW Debugger Enhancements: You can now display compound variable values such as user-defined types, records and cursors
  • Powerful PL/SQL Editor: With its Syntax Highlighting, SQL and PL/SQL help, Object Descriptions, Code Assistant, Compiler Hints, Refactoring, PL/SQL Beautifier, Code Contents, Code Hierarchy, Code Folding, Hyperlink Navigation, Macro Library and many other sophisticated features, the Unicode compliant editor will even appeal to the most demanding user.
  • Integrated Debugger: The integrated debugger offers all features you could wish for: Step In, Step Over, Step Out, Run Until Exception, Breakpoints, View & Set Variables, View Call Stack and so on. You can debug any program unit without making any modification to it, including triggers and object types.
  • PL/SQL Beautifier: The PL/SQL Beautifier allows you to format your SQL and PL/SQL code through a user-defined set of rules. Your code can automatically be beautified when you compile, save, or open a file. This feature will increase your coding productivity and will improve the readability of your PL/SQL code if you are working in large project teams.
  • SQL Window: The SQL Window allows you to enter any SQL statement or multiple statements and view or edit the results in a grid.
  • Command Window: To develop and execute SQL scripts you can use PL/SQL Developer's Command Window. This window has the same look and feel as SQL Plus and additionally has a built-in script editor with corresponding syntax highlighting.
  • Reports: To run reports against your application data or against the Oracle dictionary, you can use PL/SQL Developer's built-in Report functionality.
  • And many more

Product Features

PL/SQL Developer is an Integrated Development Environment for developing, testing, debugging and optimising Oracle PL/SQL stored program units such as packages and triggers. PL/SQL Developer focuses on ease of use and code quality and productivity during Oracle application development.

Features include:

  • Powerful PL/SQL Editor: offers Syntax Highlighting, SQL and PL/SQL help, Object Descriptions, Code Assistant, Code Contents, Browse Buttons, Hyperlink Navigation and a Macro Library. Information is automatically presented when needed or is at most one click away
  • PL/SQL Editor Integrated Debugger: (requires Oracle 7.3.4 or later) offers Step In, Step Over, Step Out, Run Until Exception, Breakpoints, View and Set Variables andView Call Stack. Debug any program unit without modification, including triggers and Oracle8 object types. If using Oracle8i or later, the dbms trace facility can be used to trace the execution of PL/SQL code
  • Query Builder: create new select statements or modify existing ones. Drag and drop tables and views, select columns for the field list, where clause and order by clause and join tables based on foreign key constraint definitions
  • SQL Window: enter any SQL statement and view or edit the results in a grid. It supports a Query By Example mode to search specific records in a result set which can be exported in CSV, TSV, XML and HTML format. Recall previously executed SQL statements from a history buffer. The SQL editor provides the same features as the PL/SQL Editor
  • Command Window: use PL/SQL Developer's Command Window to develop and execute SQL scripts. This window has the same look and feel as SQL*Plus and has a built-in script editor with corresponding syntax highlighting. Develop scripts without the "edit script/save it/switch to SQL*Plus/run script" cycle and without leaving the PL/SQL Developer IDE
  • Reports: use PL/SQL Developer's built-in Report functionality to run reports against application data or against the Oracle dictionary. There are a number of standard reports and custom reports can be created that can be saved in a report file which can in turn be included in the reports menu. This makes it very easy to run frequently used custom reports
  • Projects: use PL/SQL Developer's built-in project concept to organise work. A project consists of a collection of source files, database objects, notes and options. It allows working within the scope of a specific set of items instead of a complete database or schema. This makes it easy to find the project items, to compile all project items or to move a project from one location or database to another
  • Object Browser:a configurable tree-view that displays all information that is relevant to PL/SQL development. Use it to obtain object descriptions, to view object definitions, to create test scripts for the debugger, to enable and disable triggers and constraints, to recompile invalid objects, to query or edit table or view data, to search for text in object sources andto drag and drop object specific information into an editor. The Object Browser displays dependencies among objects (package references view, view references table) and allows them to be recursively expanded
  • Performance Optimising: use the PL/SQL Profiler to view timing information of each executed line of PL/SQL code (Oracle8i and later) and to optimise the performance to SQL and PL/SQL codeObtain statistics on executed SQL statements and PL/SQL programs automatically. These statistics can include CPU usage, block I/O, record I/O, table scans andsorts
  • HTML Manuals: Oracle currently supplies on-line manuals in HTML format that can be integrated into PL/SQL Developer's environment to provide context sensitive help during editing, compilation errors and runtime errors
  • Non-PL/SQL Objects: View, create and modify tables, sequences, synonyms, libraries, directories, jobs, database links, users, roles and profiles without using SQL. Enter the information in an easy to use form and allow PL/SQL Developerto generate the appropriate SQL to create or alter the object
  • Template List: use the template editor to save time and enforce standardisation. Click on the corresponding template or right-click in an editor and select the corresponding template from the popup menu to insert standard SQL or PL/SQL code into an editor or to create a new program file from scratch
  • Compare User Objects: propagate changes to table definitions, views and program units to another database user or find out the exact differences in another development environment, a testing environment or a production environment. The Compare User Objects function compares a selection of objects to visualise the differences and to execute or save a SQL script that will apply the necessary changes
  • Export User Objects: use the Export User Objects tool to export the DDL (Data Definition Language) statements of a selection of objects of a user to re-create the objects for another user or to save the files as a backup
  • Tools: PL/SQL Developer includes several tools to make everyday development easier. Recompile all invalid objects, search for text in database sources, import and export tables, monitor dbms alert and dbms pipe events and view session information. Define external tools to launch from within the PL/SQL Developer IDE
  • Plug-In extensions: the functionality of PL/SQL Developer can be extended through Plug-Ins that are supplied onan Add-ons pagefor free downloading. Plug-Ins can bewrittenusing aprogramming language that can create DLL's,
  • Multi-threaded IDE: PL/SQL Developer is a multi-threaded IDE making it possibleto work whilst SQL queries are executing, PL/SQL programs are executing or debug sessions are running. It also means that the IDE will not "hang" if a programming error is made: break execution or save work at any time
  • Easy installation:SQL*Net is the only middleware that is required. There is no database object installation.

PL/SQL Developer 8.0 - New Features

  • DBMS Scheduler tool added
  • Object Browser enhancements
  • New docking interface
  • File Browser added
  • Editor enhancements
  • Project enhancements
  • SQL Window enhancements
  • Table Definition Editor enhancements
  • Compiler preferences added
  • Diagram Window enhancements
  • Text Importer enhancements
  • PL/SQL Beautifier enhancements
  • Tool enhancements
  • New command-line parameters

Back to top

Requirements

System requirements

PL/SQL Developer will run on Windows 2000, XP, 2003, Vista and Windows 7. The supported Oracle Server versions are 7.x, 8.x, 8i, 9i, 10g and 11g on any platform. To connect to an Oracle database, PL/SQL Developer requires a 32-bit SQL*Net, Net 8, Net 9, Net 10 or Net 11 version.