| 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
|
| 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:
|
| Text Importer enhancements The Text Importer has been enhanced in the following ways:
|
| PL/SQL Beautifier enhancements The PL/SQL Beautifier has been enhanced in the following ways:
|
| Tool enhancements Several tools have been enhanced based on user feedback:
|
| New command-line parameters The following command-line parameters have been added:
|