Online Documentation for SQL Query for Oracle

Query Builder

General options

 

Select condition row

Displays the selected condition in different rows within the Criteria and Grouping criteria tabs of Visual Query Builder.

 

Drag field name

Displays the dragged field name in the Builder area.

 

Hide selection when inactive

Hides the current selection when Visual Query Builder is inactive.

 

Show field types in hints

Displays field types next to the field names in the table box.

 

Clear condition on query type changing

Check this option to clear the condition when the query type is changed. Otherwise it will be saved, and you can therefore use your condition for the UPDATE statement in the next SELECT statement to view the updated data.

 

 

Visible tabs

These options specify which Visual Query Builder tabs are available and which are not. Check the boxes to make the corresponding tabs visible.

 

Script format

These options specify the case formatting of keywords and functions in the query text within the Edit 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.

 

 

 

Style

These options specify the way various Visual Query Builder elements look: the Condition button: Flat, 3DLook, Raise; object borders: Bump, Etched, Raised, Sunken. If necessary, you can also specify flatness for objects and buttons using the corresponding options.

 

Additional

 

XP tables style

This option determines the appearance of non-client areas of tables in Visual Query Builder.

 

Union all by default

With this option set, new union subqueries will be united with already existing subqueries by the UNION ALL clause, otherwise - by the UNION clause.

 

Use ANSI join

ANSI SQL standard will be used when generating join script for tables.

 

Only select mode

Check this option to disable building of the INSERT, UPDATE and DELETE statements.

 

Use icons

With this option selected, you can see the icons next to the database objects in Visual Query Builder.

 

 

---