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.
Editing a result set
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
The graph can be edited, saved, printed, placed on the clipboard, and can be used as a template for future graphs.