Instead of opening a file selector to open or save files, you can access them directly from PL/SQL Developer's work area. project directories, tool directories, and so on), you can use the File Browser for quick and easy access. If you frequently access source files and scripts from a limited set of locations (e.g. package references view, view references table, super/subtypes, and son on). The Object Browser additionally displays dependencies among objects, and lets you recursively expand these dependant objects (e.g. Use it to get object descriptions, to view object definitions, to create test scripts for the debugger, to enable and disable triggers and constraints, to recompile invalid objects, to query or edit tables or view data, to search for text in object sources, to drag and drop object names into an editor, and so on. This configurable tree-view displays all information that is relevant to PL/SQL development. You can access this information later from the To-Do List, either at the object level or at the project level. You can use To-Do 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 run Test Sets from the Command Window for automated regression testing. In case of an error, the Test Manager can launch the Debugger to investigate the cause of the error. ![]() You can define and run a Test Set, and quickly determine if all tests run correctly. Regression Testingįor regression testing you can use PL/SQL Developer's built-in Test Manager. This makes it easy to find the project items you need, to compile all project items, or to move a project from one location or database to another. It allows you to work within the scope of a specific set of items, instead of a complete database or schema. A project consists of a collection of source files, database objects, notes, and options. To organise your work you can use PL/SQL Developer's built-in project concept. Right-clicking on an object provides access to all object functions, and double-clicking on an object will invoke the default action for the object type. A diagram can be used for documentation purposes, but can also serve as a workspace. This way you can easily visualise (a part of) the database objects of your application or project and their relations. The Diagram Window allows you to create a graphical representation of a selection of objects. You can use the Query Reporter freeware tool to run your reports without PL/SQL Developer, and to run them from the command-line. This makes it very easy to run your own frequently used custom reports. ![]() These custom reports can be saved in a report file, which can in turn be included in the reports menu. There are a number of standard reports, and you can easily create your own custom reports. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |