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 greatly helps you facilitate your database development:
When modifying Oracle database structure, transferring data between servers, analyzing differences between databases, you can use oracle database management tools to:
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:
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.
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.
Improve multi-second queries using Oracle SQL Profiler. The tool helps you detect problems and optimize SQL queries via GUI. Profiler:
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:
Tools for Oracle administration and management serve for:
Enjoy oracle database design. Use database diagram for creating, analyzing, reverse-engineering, printing and customizing your Oracle databases and for:
Export and import Oracle data for filling databases. dbForge Studio can export data to 11 popular formats and import it from 8 formats. Oracle import and export processes are customizable, and can be automated via the command-line interface.
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.