dbForge Studio for Oracle Features
- PL/SQL coding assistant
- Automatic code completion in PL/SQL editor.
- Code snippets.
- Quick information on schema objects.
- Document outline for navigation.
- Smart PL/SQL formatter.
- Database Project
- Database project greatly helps you facilitate your database development:
- Create a database project either empty or with imported database objects.
- Manage SQL scripts and query files in the project.
- Deploy either an entire project or only required changes to the server.
- Oracle Database Management
- When modifying Oracle database structure, transferring data between servers, analyzing differences between databases, you can use Oracle database management tools to:
- Perform Oracle data comparison.
- Perform Oracle database synchronization.
- Schedule regular database sync tasks.
- Generate comparison Oracle report.
- Data Generator
- Populate your Oracle tables with thousands of rows of realistic test data. Data Generator supports essential Oracle data types, includes 200+ meaningful generators with customizable settings, and allows generating data via the command-line interface.
- Documenter
- Generate Oracle database documentation in a wink. The Documenter feature allows you to:
- Generate documentation files in the HTML, PDF and Markdown formats.
- Retrieve an overview of the database structure.
- View inter-object and inter-database dependencies.
- Object Manager
- Database objects are displayed as a tree in Database Explorer. To edit any object, you can call the corresponding visual editor from this window. You can:
- Manage tables from one window.
- Use Undo option for object editor.
- Use ability to browse schema objects in a single Oracle editor (pin document).
- Oracle PL/SQL Debugger
- The Oracle debugger serves for step-by-step execution of stored program units and SQL scripts. Oracle developers can edit, compile, run, and debug PL/SQL code easily. They can use breakpoints, evaluate and modify variables in the Watches window, and analyze the currently active stack of your PL/SQL program calls in the Call Stack window.
- Query Builder
- Create complex queries visually without effort. The tool allows you to design SELECT statements with multiple tables, joins, and complex subqueries without manual typing of code. Just drag-and-drop required objects onto a visual designer to generate SQL statements.
- Query Profiler
- Improve multi-second queries using Oracle SQL Profiler. The tool helps you detect problems and optimize SQL queries via GUI. Profiler:
- Offers visual query profiling.
- Compares profiling results.
- Schema Import/Export
- Export full schema structure or selected schema objects, copy database objects using schema export/import wizards. While using the wizards, you can benefit from the following features:
- Oracle data import and export utility wizards.
- Schema export projects.
- Zip compression for export output files.
- Command-line support.
- Database Administration
- Tools for Oracle administration and management serve for:
- Managing user privileges.
- Managing server sessions.
- Monitoring events.
- Database Designer
- Enjoy Oracle database design. Use database diagram for creating, analyzing, reverse-engineering, printing and customizing your Oracle databases and for:
- Viewing foreign key relations.
- Displaying DB objects with properties.
- Execution of stored routines.
- Import/Export Data
- Export and import Oracle data for filling databases. dbForge Studio can export data to 14 popular formats and import it from 10 formats. Oracle import and export processes are customizable, and can be automated via the command-line interface.
- Report and Analysis
- Data analysis and reporting are performed with the help of Oracle reporting tools, data reports, pivot tables, and viewing master-detail relations. Comprehensive wizards and tools can display data as charts and tables, and provide means for adjusting data layout, grouping, sorting, etc.
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
- 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