issues faster

Database Tools

Must-have SQL Server tools and tools for MySQL, Oracle, and PostgreSQL database development, management and administration

Data Connectivity

The most trusted solutions for your data connectivity needs: ADO.NET, ODBC, SSIS, Excel, dbExpress, Delphi Components

Productivity Tools

Write code, create reviews, compare sources, track the working hours with the web app, utilize the power of ORM Solutions

Data Services

Data integration, online backup, web-based SQL tools, cloud connectivity solution

dbForge Studio for Oracle 3.1 with Improved PL/SQL Coding, Data Editing, and Higher Performance is Here!

December 6, 2011

Devart is glad to release the new improved version of dbForge Studio for Oracle, v 3.1.

We've analyzed user feedbacks received after the release of the completely redesigned dbForge Studio and defined prior points for further development of the product.

As a result we've devoted the new release of dbForge Studio for Oracle to improving the possibilities for users who work with PL/SQL code and data. And in addition we've improved the application performance and added support for Win-x64 platform.

New Features

  • 150 improvements in the code autocompletion system

    We've made nearly 150 changes and improvements in the dbForge Studio for Oracle component that helps users edit PL/SQL code. Among them:

    • Oracle SQL and PL/SQL syntax support is expanded
    • Work of quick info hints for schema objects is improved
    • Keywords case is changed automatically on typing (if the corresponding options are set)
    • Usability shortcomings and errors are fixed
  • SQL document works with additional PL/SQL file types:

    • Support for editing .pls, .plb, .pks, .pkb, .pck Oracle PL/SQL files is added
    • Support for editing files with PL/SQL code created in some competitor products is added
  • Data export to SQL statements

    • Possibility to export data to INSERT, UPDATE, DELETE, and MERGE statements is added
    • Data can be exported from a table or data grid using a wizard
    • Quick export from data grid without opening wizard
  • Convenient work with result sets of several SELECT queries

    If there is more than one SELECT statement in a document, after execution query results will be displayed on separate tabs in the Data window.

    Such approach allows working with each data set independently.

  • Editing data of object fields

    The new product version provides possibility to edit data in object fields in tables using a pop-up editor.

  • Support for editing temporary tables

    There is a capability to create and edit temporary tables in Table Editor.

  • Document Outline window for code navigation is improved

    • Grouping nodes by IF, FOR, etc. flow-control statements blocks is added
    • Displaying labels and navigation among them is added
  • More convenient working with query execution plan

    • Quick query plan obtaining (without turning the Profiling mode on) is added
    • Displaying of the EXPLAIN PLAN results without creating an additional table in the user's scheme is added
  • Performance improvements

    • Time required on application startup and connection opening is reduced
    • Building of the Database Explorer tree, refreshing it, and receiving table list is quicker now
    • Getting metadata for code completion becomes faster
    • Work of Schema Export with large amount of objects and data is improved
    • Data Editor working speed is increased
    • Object Viewer and Property Browser windows working speed is increased
    • Navigation to schema object editors from code is improved
  • Win-x64 Native Support

    Now the application does not require 32-bit Oracle client software installed when working with 64-bit Windows operating system - the application works with 64-bit Oracle client software.


Consumers can give the updated dbForge Studio for Oracle a test drive by downloading the free Express edition or the 30-day trial Professional edition at the product download page. dbForge Studio license price starts at $149.95.

To leave feedback, users can go to the dbForge Studio for Oracle feedback page. The Devart team is looking forward to receiving any comments and suggestions.