PL/SQL Developer - The SQL Window


With the SQL Window you can execute any SQL statement or PL/SQL Block, or a script with multiple statements and PL/SQL Blocks. You can recall, edit and re-execute all previously executed statements. For select statements you can view the results in a grid or in a single record form, and can update, insert or delete records easily.

The Query By Example mode makes it easy to search specific records in the result set. In QBE mode you can simply provide query values with wildcards for one or more fields to find the matching records. The SQL text in the editor will automatically be updated to reflect the query.

The results (or a selection of the results) can also be printed, copied to the clipboard, saved as a CSV, TSV, XML or HTML file, or exported to Excel.

To analyze results you can use the compare function to highlight different or identical records or columns.

The Linked Query feature makes it easy to query a parent record or child records of the selected record, based on foreign key definitions. Just press the Linked Query button, select the foreign key from the list, and a query for the corresponding record(s) is executed in the same SQL Window or in a new one. If you select a different record in the parent in the parent SQL Window, the result set in the child SQL Window will automatically be refreshed.

The SQL Editor has the same powerful features as the PL/SQL Editor. For optimization purposes you can view the resource usage of each executed SQL statement on the Statistics page.

Editing a result set
In a result set you can easily update, insert or delete records. Dictionary information is automatically displayed as you navigate through the result set. In the example above, information for the deptno column is displayed on the status line, and a lookup is presented for parent records from the dept table. For date fields you can select a date and time from a calendar popup.

For CLOB, BLOB, BFILE, LONG, LONG RAW and VARCHAR2 fields you can view the contents in various formats the Large Data Editor:

Very often these fields will contain unformatted or formatted text (XML, HTML, RTF) or images (BMP, JPG, GIF, TIFF). These data types can immediately be viewed within the Large Data Editor. You can also view and edit the data in hexadecimal format.

Furthermore you can invoke an external application to view or edit the data. For example, if you store MS Word documents in a BLOB column, you can associate msword.exe with this column. Whenever you view or edit this column, the data will first be saved to a temporary .doc file, which will subsequently be opened in MS Word. When you save the file from MS Word, the data will be reloaded into the field.

Displaying a graphical representation of a result set
To quickly display a graphical representation of a result set, you can press the Graph button to launch the Graph Wizard. It allows you to select a column for the X-axis and Y-axis and various visual style properties, after which a Graph Window will be displayed:

The graph can be edited, saved, printed, placed on the clipboard, and can be used as a template for future graphs.