Devart Blog

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

Posted by on December 7th, 2011

We’ve analysed 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.

dbForge Studio for Oracle v3.1

dbForge Studio for Oracle v3.1

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.

Availability

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.

Leave a Reply