About dbForge Studio for Oracle

Development environment for working with Oracle databases.

dbForge Studio for Oracle (formerly known as OraDeveloper Studio) is a powerful integrated development environment (IDE) which helps Oracle SQL developers to increase PL/SQL coding speed, provides versatile data editing tools for managing in-database and external data. This tool allows synchronizing data between different Oracle servers and automating schema change management process during development. This Oracle database manager has lots of features wrapped into a smooth management Oracle GUI consistent with Microsoft Visual Studio.

dbForge Studio for Oracle Features

  • PL/SQL Development - Write and format code on the fly, debug procedures, functions, and triggers, optimize query performance and eliminate bottlenecks.
  • Data Modeling and Design - Design Oracle databases visually, build queries in a few clicks, create and edit database objects.
  • Change Management and Data Manipulation - Migrate schemas and data between databases, manage data and schema diffs.
  • Analysis and Data Reporting - Design data reports, charts, pivot tables with parameters, customizable formatting, and calculated summaries. dbForge Studio for Oracle includes the following tools for efficient data reporting and analysis.

dbForge Studio for Oracle Standard Features

  • SQL Development
    • PL/SQL editor with syntax highlight, bookmarks, and text search
    • PL/SQL debugger
    • PL/SQL formatter
    • Context-sensitive code completion
    • Click to view restrictions
    • Phrase completion
    • Quick information about schema objects
    • Parameter information for stored routines
    • Visual Query Builder
    • Alias refactoring
    • Object refactoring
    • Navigation to the schema object editor from code
    • Code snippets
    • Customizable DDL generation wizard
    • Query Profiler
    • Highlight occurrences
    • Query History
  • Database Design
    • Visual editors for schema objects
    • Database Diagrams
    • Find object in a database
    • Object Viewer window
    • Dependencies tree
    • Find and Recompile Invalid Objects
  • Administration
    • Security Manager
    • Session Manager
    • Event Monitor
  • Data Pump
    • Data import and data export.
    • Schema export and import (dump)
    • Schema snapshot generation
  • Data Analysis
    • Find data record in a database
    • Data editor with in-place filtering, grouping, and sorting
  • General
    • Oracle 12с R2, 12c, 11g R2, 11g, 10g, 9i, 8i*, Oracle Express Edition (Oracle XE) databases support
    • OS authentication
    • Restore last opened tabbed document
    • Connection coloring and document categories
    • Amazon RDS support
    • Direct Oracle database connection (without client)
    • Multiple database connections in Database Explorer window
    • Full shortcut customization
    • Wizards for exporting/importing user settings

dbForge Studio for Oracle Professional Features - includes everything in the Standard Edition plus the following:

  • SQL Development
    • Formatting code through the command line
  • Database Design
    • Database projects
    • Schema comparison and synchronization tool
    • Command-line interface for schema comparison and synchronization
  • Data Pump
    • Data comparison and synchronization tool
    • Command-line interface for data comparison and synchronization
    • Data import/export through the command line
    • Schema import/export through the command line
    • Schema snapshot generation through the command line
    • Integration with version control systems
  • Data Analysis
    • Pivot tables
    • Data reports
    • Creating data reports through the command line
    • Automated data report delivery
    • Master-Detail Browser

dbForge Studio for Oracle Enterprise Features - includes everything in the Professional Edition plus the following:

  • Data Generator with 200+ predefined meaningful data generators
  • Generation of Database Documentation in HTML, PDF, Markdown file formats