Online Documentation for SQL Manager for Oracle
Design query
Design Query is implemented in SQL Manager for Oracle for building queries visually. The tool allows you to create and edit queries without deep knowledge of SQL. You can also prepare and execute queries, and view the results of their execution.
To open Design Query, select the Tools | Design Query main menu items or use the corresponding 
toolbar buttons.
- Using Navigation bar and Toolbar
- Working with diagram area
- Joining two database objects by fields
- Setting the selection criteria
- Setting output fields for selection
- Setting the grouping criteria
- Setting parameters of sorting
- Working with editor area
- Executing queries and viewing results
- Viewing query plan
|
Availability: |
|
|
Full version (for Windows) |
Yes |
|
Lite version (for Windows) |
No |
|
Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page. |
|
|
See also: |
