dbForge Studio for Oracle

Powerful Oracle Database Development Tool

dbForge Studio for Oracle (formerly known as OraDeveloper Studio) is a powerful Oracle database development environment.

It helps you to increase PL/SQL coding speed, provides you versatile data editing tools for managing in-database and external data. It allows you to synchronize data between different Oracle servers and automate schema change management process during development. Product also adds many other features wrapped into a smooth UI consistent with Visual Studio.

PL/SQL coding assistant

  • Automatic code completion and statement expansion
  • Code snippets for re-using PL/SQL fragments
  • Quick information on schema objects in a popup window
  • Document outline window for navigation through code

View Screenshot

Data management tools

  • Data editor with quick filtering, sorting, grouping, copying to spreadsheet, and export to SQL
  • Data export and import supporting multiple formats
  • Data reports designer with report generation in multiple formats for Oracle
  • Master-detail data browser
  • Pivot table designer

Video: Data editor demo

Database change management tools

  • Schema comparison and synchronization tool for Oracle
  • Schema snapshots creation and comparison
  • Data comparison and synchronization tool for Oracle
  • Command-line interface support for database development process automation

Video: Comparing and syncrhonizing two schemas
Video: Data comparison and sychronization example

Other features

Editions

dbForge Studio for Oracle comes in three editions:

Express gives you the basic FREE Oracle database tool. It includes schema object editors, security manager, basic code completion, basic data export and import, restricted query builder.

Standard works fine for everyday Oracle development tasks. It adds advanced code completion, PL/SQL debugger, database search, query profiler.

Professional includes extra tools to advance your Oracle development to a new level. It adds database projects, schema comparison tool, data comparison tool, command-line interface.

You can find the detailed edition comparison table here.