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
More on PL/SQL Debugger
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.