To run reports against your application data or against the Oracle dictionary, you can use PL/SQL Developer's built-in Report functionality. Now you can develop your scripts without the "edit script / save it / switch to SQL*Plus / run script" cycle, and without leaving the comfortable PL/SQL Developer IDE. This window has the same look and feel as SQL*Plus, and additionally has a built-in script editor with corresponding syntax highlighting. To develop and execute SQL scripts you can use PL/SQL Developer's Command Window. The SQL editor provides the same powerful features as the PL/SQL Editor. You can easily recall previously executed SQL statements from a history buffer. The result grid supports a Query By Example mode to search specific records in a result set.
The SQL Window allows you to enter any SQL statement or multiple statements and view or edit the results in a grid. This feature will increase your coding productivity and will improve the readability of your PL/SQL code if you are working in large project teams. Your code can automatically be beautified when you compile, save, or open a file. The PL/SQL Beautifier allows you to format your SQL and PL/SQL code through a user-defined set of rules. You can debug any program unit without making any modification to it, including triggers and object types.
The integrated debugger offers all features you could wish for: Step In, Step Over, Step Out, Run Until Exception, Breakpoints, View & Set Variables, View Call Stack, and so on. Information is automatically presented to you when you need it, or is at most one click away. With its Syntax Highlighting, SQL and PL/SQL help, Object Descriptions, Code Assistant, Compiler Hints, Refactoring, PL/SQL Beautifier, Code Contents, Code Hierarchy, Code Folding, Hyperlink Navigation, Macro Library and many other sophisticated features, the Unicode compliant editor will even appeal to the most demanding user. The following are major features of PL/SQL Developer PL/SQL Developer focuses on ease of use, code quality and productivity, key advantages during Oracle application development.
Over time we have seen more and more business logic and application logic move into the Oracle Server, so that PL/SQL programming has become a significant part of the total development process. PL/SQL Developer is an Integrated Development Environment that is specifically targeted at the development of stored program units for Oracle Databases.
0 kommentar(er)
