This way you can easily visualize (apart of) the database objects of your application or project andtheir relations. The Diagram Window allows you to create a graphical representationof a selection of objects. This makes it very easy to run your own frequentlyused custom reports. These custom reports can besaved in a report file, which can in turn be included in thereports menu. There are a number of standard reports, and you caneasily create your own custom reports. To run reports against your application data or against the Oracledictionary, you can use PL/SQL Developer’s built-in Reportfunctionality. 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 correspondingsyntax highlighting. To develop and execute SQL scripts you can use PL/SQL Developer’sCommand Window. The SQL editor provides the samepowerful features as the PL/SQL Editor.
You can easily recall previously executed SQLstatements from a history buffer. The result gridsupports a Query By Example mode to search specific records in aresult set. The SQL Window allows you to enter any SQL statement or multiplestatements and view or edit the results in a grid. This featurewill increase your coding productivity and will improve thereadability of your PL/SQL code if you are working in large projectteams. Your code can automatically bebeautified when you compile, save, or open a file. The PL/SQL Beautifier allows you to format your SQL and PL/SQL codethrough a user-defined set of rules. You can debugany program unit without making any modification to it, includingtriggers 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 needit, or is at most one click away. With its Syntax Highlighting, SQL and PL/SQL help, ObjectDescriptions, Code Assistant, Compiler Hints, Refactoring, PL/SQLBeautifier, Code Contents, Code Hierarchy, Code Folding, HyperlinkNavigation, Macro Library and many other sophisticated features,the Unicode compliant editor will even appeal to the most demandinguser. Here are some key features of”PL/SQL Developer”: PL/SQL Developer focuses onease of use, code quality and productivity, key advantages duringOracle application development. Over time we have seenmore and more business logic and application logic move into theOracle Server, so that PL/SQL programming has become a significantpart of the total development process. PL/SQL Developer is an Integrated DevelopmentEnvironment that is specifically targeted at the development ofstored program units for Oracle Databases.
0 kommentar(er)
