PL/SQL Developer Tools - PL/SQL Formatter, Code Completion, Code Snippets

Performance of any PL/SQL developer depends not only on their knowledge and skills, since development environment used to implement tasks is of great importance too. Getting familiar with dbForge Studio for Oracle is a pleasure owing to, first of all, its extended means in terms of work with the PL/SQL code. However, the functionality of this tool is not limited only to convenient work with PL/SQL. Let's consider the tool's features step by step.

Automatic code completion

Among all features of dbForge Studio for Oracle, the most important one is the smart code completion support that allows you to speed-up the process of writing SQL queries and PL/SQL code.

dbForge Studio for Oracle analyzes the current block of code, and prompts objects depending on the context. The obtained results are displayed so that the most relevant constructs are on the top of the list.

Column Picker

When you type a statement, Column Picker prompts a complete list of relevant tables and columns. In the suggestion box, you can select several objects at once and they will be added to your SQL document.

Besides, as you type a column name, the list of suggested columns is filtered according to the letters being typed and the relevant names are shown on the top of the list.

Quick information on schema objects

In order not to waste time on search in the database, it is important to have up-to-date information on objects existing in the database available during the process of development.

This is why the tool provides PL/SQL developers with the feature of object properties display right from the code window.

Code snippets

Recurrent usage of code snippets contributes not only to speed-up, but also to simplifying the PL/SQL developer's work, since there are ready snippets available for all basic constructs.

Besides, a snippet can be added from the code auto-completion window without developer's being distracted by another window. Furthermore, you can add a new snippet, or edit any existing one using the built-in PL/SQL editor.

Smart PL/SQL formatting

It is important to retain code readability at the stage of writing it. But what should a PL/SQL developer do if code is already written and its manual PL/SQL formatting might take too long?

The answer is simple: they can use the functionality of dbForge Studio for Oracle that allows formatting not only PL/SQL syntax, but also supports peculiarities of the PL/SQL language, and, at the same time, allows customizing all basic constructs extensively.

Integrated debugger

As is often the case with errors, their reasons may be implicit. In order not to perform manual search, which is often time-consuming, you can use the integrated debugger of dbForge Studio for Oracle, that allows you both to navigate inside code, and analyze call stack, or view variable values.

Document outline for navigation

Remember how often you had to endlessly scroll trough PL/SQL code listing in the hope of finding the required construct. This torture is over, since dbForge Studio for Oracle supports navigation between language constructs. A separate Document Outline window is designed for this purpose.

Code Refactoring

With dbForge Studio for Oracle, you can quickly rename tables, views, stored procedures, packages, functions, triggers, sequences, user types, materialized views, synonyms, clusters, and variables. The tool will automatically replace all references to the renamed objects. In addition, you can view all changes in the Rename window.