PL/SQL Developer

What is PL/SQL Developer?

PL/SQL Developer is an integrated development environment that is specifically oriented towards the development of stored program units for Oracle databases.

Over time, we've seen more and more business logic and application logic move to Oracle Server, so PL/SQL programming has become a significant part of the overall development process.

The PL/SQL developer focuses on ease of use, code quality, and productivity, the main advantages when developing Oracle applications.

The main features of PL/SQL Developer:

Powerful PL/SQL Editor

With the feature of syntax highlighting, SQL and PL/SQL, object descriptions, Code Wizard, Compiler Tips, Refactoring, Beautifier PL/SQL, Code Content, Code Hierarchy, Code Folder, Hyperlink Navigation, Macro Library and many other sophisticated features, the Unicode Compatible Editor will even attract the most demanding user. The information is automatically presented when you need it, or you're one more click away.

Command window

To develop and run SQL scripts, you can use the PL/SQL Developer Command Window. This window has the same look and feel as SQL Plus/run script" and without leaving the comfortable DEVELOPER IDE PL/SQL. Reports To run reports against your application data or the Oracle dictionary, you can use the built-in PL/SQL Developer Reporting functionality. There are a number of standard reports, and you can easily create your own custom reports. These custom reports can be saved to a report file, which can in turn be included in the reports menu. This makes it very easy to run your own frequently used custom reports.

Items to make

You can use task items in any SQL or PL/SQL source file to make a quick note that something needs to be done in this source file. You can access this information later from the Task List, both at the object level and at the project level.

Object researcher

This configurable tree-view displays all information relevant to PL/SQL development. Use it to get descriptions of objects, to view object definitions, create test scripts for the debugger, enable and disable triggers and constraints, recompile invalid objects, query or edit tables, or view data, search for text in object fonts, to drag and drop object names in an editor, and so on.

Performance Optimization

To optimize performance in your SQL and PL/SQL code, you can use PL/SQL Profiler to view timing information for each executed row of PL/SQL code (Oracle8i and later). In addition, you can automatically get statistics about SQL statements executed and PL/SQL programs. These statistics may include CPU usage, I/O lock, registry I/O, table scans, types, and so on. HTML manuals Oracle provides online manuals in HTML format.

Query builder

The Graphical Query Builder makes it easy to create new selection statements or modify existing ones.

The built-in PL/SQL developer plug-in interface enables third-party query builders, such as Active Query Builder. Comparing user objects After you make changes to table definitions, visualizations, program units, and so on, it can be useful to propagate those changes to another database user or find out exactly what the differences are. This can be another development environment, a test environment, or a production environment.

Requirements of sistema:

CPU: 1.8 GHz dual core processor

RAM: 2 GB

HDD / SSD: 50 GB of free space on the main drive

Operating system: Microsoft Windows 10, Microsoft Windows 8 32-bit, Microsoft Windows 7 32-bit and Microsoft Windows Vista 32-bit

Resolution: 1024×768