PL/SQL Developer - Reports


The Report Window is very easy to use, and yet it can provide all information that is available in your own application tables or in the Oracle Dictionary in a structured layout that is pleasant to the eye.

At design-time you merely need to provide a select statement that provides the data. You can of course use the powerful features of the SQL Editor and the Query Builder to write this select statement.

You can use an advanced form of substitution variables in your SQL, so that you can provide some input when the report is run. For each variable you can specify a description, hint, data type, default value, selection list, checkbox values, and so on.

After you are satisfied with the query of the report, you can modify the layout of its result set. You can define master/detail and break structures, change colors, fonts, alignment, descriptions, and so on. The layout is formatted in HTML, which allows you to use any HTML and CSS attributes. You can use a Style Library to define commonly used report styles.

The report results can be saved in an HTML file, so that you can view it through a Browser at a later time, or include it in a document, or send it to others. The design-interface of the report will be hidden when you run a report, so that you can focus on the information.

The report data can additionally be exported in XML, CSV, TSV or Excel format, and can also be displayed in a Graph Window.

The security options of a report allow you to provide reports to others that need to be executed through a privileged Oracle account (e.g. SYS), without providing the password of this account.