What’s New in OraDeveloper Tools, v2.0

Oracle Database Project Support

Oracle database project integrates your database developments into the single whole. You can work with Oracle database project just like with other Visual Studio projects. Oracle database projects can be deployed and compiled. Project deployment means, that selected projects scripts and queries can be executed in deployment order, that can be customized. Project compiling means compiling source objects contained in project, if they are already deployed on server.

PL/SQL and Script Debuggers

PL/SQL debugger allows developer to debug various kinds of Oracle source objects. The program execution can be stopped on any line of executable code when using breakpoints. Debugger provides the possibility of evaluating and modifying variables in the Watches window. The currently active stack of PL/SQL program calls is shown in the Call Stack window. Script debugger allows to fulfill step-by-step execution of SQL scripts with the possibility of breaking the execution.

Security Manager

Security Manager allows administrators to perform the full range of database security administration tasks such as manipulating user accounts, granting and revoking roles and privileges, managing profiles.

SQL Editor Improved

SQL Editor is now greatly improved. Following features are available:

  • Code completion was extended with keywords and objects from parsed script.
  • Parameter information is now available.
  • Quick information about pointed object in the script added.
  • In-place visual select statements editing with Query Builder window.

Working with Data Improved

Following features added for working with data:

  • You can now print data from data editor directly.
  • Sequential fetch feature was added - not all the data can now be fetched at once, cursor can be left opened to fetch data later.
  • Data output can now be redirected to the Output window to view data as text.
  • Card View mode was added to view data rows as cards.

Extended Support of Oracle Schema Objects Editing

New version has increased the number of database objects which can be created by convenient and multifunctional editors. Here is the list improvements:

  • XML Schemas and tables
  • Object Tables
  • Partitioned, clustered and index-organized tables
  • Materialized Views and Materialized View Logs

Session Manager

Session Manager allows administrators to control and analyze user sessions.

Event Monitor

Event Monitor gives the opportunity of signal interchange between database connections using alerts and pipe messages.

Database Object Search Extended

Searching PL/SQL objects by object sources and search in object data is available now. You can now search subobjects such as columns, constraints and indexes.

Document Outlining

Document Outline window permits to view the structure of the documents with SQL text. DML commands, DDL statements, PL/SQL blocks and variables are represented as main structural units in the window to simplify code navigation.

Code Templates

A number of SQL and PL/SQL code templates were created to simplify working with SQL code.

Other new features

  • Now you can open object editors for the same type of object in the same document.
  • Output window now provides several panes for different kinds of messages.