Online Documentation for SQL Manager for Oracle
Allow SELECT queries only
When this option is checked, the INSERT, UPDATE and DELETE statements are not allowed in Design query.
Select condition row
Displays the selected condition in different rows on the Criteria and Grouping Criteria tabs of Design query.
Drag field name
Displays the dragged field name in the Builder area.
Hide selection when inactive
Hides the selection when the Design Query window is inactive.
Show field types
Displays the field data type next to the field name in the table box.
Union all by default
Check this option to use the UNION ALL expression in Design Query by default.
The UNION keyword allows you to include the results of two SELECT statements in one resulting table.
The ALL parameter incorporates all rows into the results, including duplicates. If not specified, duplicate rows are removed.
Show DBMS output
Enables/disables redirection of DBMS output to Design Query log.
Enable this option if you want to use ANSI-92 standard in join's construction.
These options specify which Design Query tabs are available and which are not. Use the check boxes to make the corresponding tabs visible/invisible.
These options specify case formatting of keywords and functions in query text within the Query tab: As is keeps the original case, Uppercase sets all the keywords/functions to the upper case, Lowercase sets all the keywords/functions to the lower case, and First upper sets the first letters of all keywords/functions to the upper case.
Additionally, you can set styles and color for all Design Query objects by using Style & Color Palette.