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 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 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 is now greatly improved. Following features are available:
Following features added for working with data:
New version has increased the number of database objects which can be created by convenient and multifunctional editors. Here is the list improvements:
Session Manager allows administrators to control and analyze user sessions.
Event Monitor gives the opportunity of signal interchange between database connections using alerts and pipe messages.
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 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.
A number of SQL and PL/SQL code templates were created to simplify working with SQL code.