PL/SQL Developer 8.0 - New Features

Below you can find a brief description of the most important new features in PL/SQL Developer 8.0.
DBMS Scheduler tool added

You can use the DBMS Scheduler tool to access the Oracle database scheduler (DBMS_SCHEDULER) provided in Oracle10g and later:

On the left side you see folders for the scheduler object types, as well as a folder for running jobs and job runs. Window groups, Windows and Job classes are system wide, and are displayed immediately in the root of the corresponding folder. Schedules, Programs and Jobs are owned by specific users, so that each folder contains subfolders for the owners. On the upper right side you see the properties of the selected object, and additional object details are displayed on the lower right side. When creating or editing objects, you can enter the information here.

The Object Browser now includes folders for the new scheduler object types for quick access. Viewing or editing a scheduler object from the Object Browser will open the DBMS Scheduler tool for the selected object.

Object Browser enhancements

In the Object Browser you can now select a user in addition to the filters from the previous release. This way you can quickly switch between users without the need for specific filters. You can additionally search for objects by using the Search text field:

The Object Browser now includes folders for indexes, constraints, java classes, window groups, windows, schedules, programs, jobs, and job classes.

New docking interface

The new docking interface allows you to pin/unpin docking areas. In the example below, the Project and Find docking areas are unpinned, and will be displayed when the mouse cursor is held over the tab at the right or bottom of the screen:

Docking areas can now additionally be maximized and restored by clicking on the corresponding button at the upper-right of the area.

New dockable tools include the Project items, To-Do items, and the new File Browser.

File Browser added

If you frequently access source files and scripts from a limited set of locations (e.g. project directories, tool directories, and so on), you can use the File Browser for quick and easy access. Instead of opening a file selector to open or save files, you can access them directly from PL/SQL Developerís work area:

From the File Browser tree you can access files and directories from user-defined locations on the local computer or on the network. You can quickly open, save, rename, and delete files here. You can use the File Browser as a docked or floating tool. By default the File Browser is located on the second tab page of the docking area of the Object Browser.

Editor enhancements

Variable declarations will now be displayed in a popup when the mouse cursor is held over the variable:

The Find function can now "search all" to highlight all search hits, and can include/exclude comments and strings:

Additional enhancements include a smart indent option, which indents automatically after begin, declare, if, and so on, the Code Assistant will now describe :OLD, :NEW, and SELF, a new "Include font style with Copy" preference is added, variable highlighting now highlights record fields, and all Oracle11g keywords are now highlighted.

Project enhancements

You can now use item groups to organize project items for larger projects. You can use these groups for limited build and make operations, to limit searches, to open/close all items, and in general to get a better overview:

The Project options screen now includes a tab page with a to-do list for all items:

You can now use the Project > Find function to search within specific project items:

Clicking on an item will subsequently bring you to the first occurrence of the search text in the file.

SQL Window enhancements
  • "Copy all to Excel" popup item added to export multiple result sets
  • Result sets greater than 64K rows will now be exported to Excel over multiple pages
  • Printing one from multiple results now also prints the related SQL
  • "Sort case sensitive" popup item added for grid columns
  • Align templates added under align button
  • Result grid now stays focused after execute
  • Values entered in grid beyond size/scale/precision of the database field are displayed in red
  • Clear Tab Results popup item added to clear a single result set
  • Running time added to status line
  • You can now receive a notification when long running queries are finished
  • Auto Refresh now implicitly reuses the current substitution variable values
  • Pasting text on the work area will create a new SQL Window when no window is available
Table Definition Editor enhancements

The Table Definition Editor now supports external tables:

In addition to this, the editor now supports subpartitions, table compression, and object columns for indexes and constraints.

Compiler preferences added

The new Compiler preferences page allows you to control many aspects of the PL/SQL Compiler:

You can set the optimize level, enable native/interpreted code, generate PL/Scope identifiers, set conditional compilation flags, control warning behavior, and set substitution variable values.

Diagram Window enhancements

The Diagram Window has been enhanced in the following ways:

  • A zoom option has been added so that you can zoom in and out of the diagram
  • Additional line-end types have been added
  • You can now print the current view and print over multiple pages
  • You can now add descriptions to lines
  • Text notes can now be added to the diagram
  • Icons and headings can be shown or hidden
  • Reference links can be added based on the dependencies between objects
Text Importer enhancements

The Text Importer has been enhanced in the following ways:

  • The Import Run can now be interrupted by pressing Escape
  • The number of failed records is now displayed
  • The generated script now has a Local/UTF8 option in the file selection dialog
  • Comment lines in the text file can now be recognized.
  • A "skip empty lines" option has been added
  • The Import to script function now tries to keep line size below 256 characters for SQL*Plus compatibility
  • You can now import a specific part of the text file (start line / end line)
  • If the text file is UTF8 encoded, the generated import script will automatically be UTF8 encoded as well
PL/SQL Beautifier enhancements

The PL/SQL Beautifier has been enhanced in the following ways:

  • -- NoFormat Start / -- NoFormat End directives can be used to suppress formatting
  • Update select lists are now formatted properly
  • Nested case expressions are now parsed and formatted properly
  • Cursor parameters are now formatted in accordance with the parameter formatting rules
  • Case expressions formatted correctly when used in conditions
  • Fetch item list now formatted correctly
  • With statement is now recognized as a standalone statement
Tool enhancements

Several tools have been enhanced based on user feedback:

  • Compare User Objects now allows you to select a user for the source objects
  • Compare User Objects now ignores differences in quoted/unquoted object names
  • Compare User Objects preserves target connection when switching main connection
  • Compare Table Data now allows you to select a user for the source tables
  • Export User Objects option added: File per object / spec & body in a single file
  • The Test Manager now shows dbms_output on the Run page
  • The Test Manager can now be launched and executed from the Command Window
  • A "wait for tool" option has been added to external tool definitions to support source modification by external tools
  • Moved columns in a Session Window will stay at the moved location after a refresh
  • Macro Editor has been improved
New command-line parameters

The following command-line parameters have been added:

  • SESSIONMODE=<SINGLE|DUAL|MULTI or 1|2|3> to force a specific session mode
  • NOSCWARNING to prevent messages about service contract expiration
  • HEXEDIT=<filename> to launch the hex editor of the large data editor for a file
  • DEFAULTPREFPATH=<path> to force a default preference directory
  • PROJECT=<filename> to open the specified project