Query Management Tools
When using SQL Manager for Oracle, you are provided with two basic tools you may need to manage your SQL queries: Query data for editing SQL query text directly and Design query for building queries visually. Find the list of common SQL query management operations below.
In order to create a new query in Query data editor:
-
select the Tools | Query data main menu item or use the corresponding
toolbar button (F12);
- click the Add new query item of the Navigation bar;
- edit the query text within the Query tab.
In order to create a new query visually in Design Query editor:
-
select the Tools | Design query main menu item or use the corresponding
toolbar button;
- build the query visually within the Builder tab.
In order to open a query in Query data editor:
-
select the Tools | Query Data main menu item or use the corresponding
toolbar button;
- use the numbered tabs at the bottom of the editor window to switch between previously edited queries. The last edited query is displayed automatically on opening the editor;
- edit the query text within the Query tab of Query Data.
In order to open a query in Design query:
-
select the Tools | Design query main menu item or use the corresponding
toolbar button;
- the last edited query is displayed automatically on opening Design Query editor;
- to load a previously saved diagram, click the Load diagram item of the Navigation bar;
- to load a query from an *.sql file, open the Edit tab and click the Load SQL button of the Navigation bar;
- edit the query visually within the Builder and/or the Query tabs.
In order to load a query from an *.sql file:
-
select the Tools | Query data main menu item or use the corresponding
toolbar button;
- click the Load from file item of the Navigation bar;
- browse for the query file using the Open SQL File dialog;
- edit the query text within the Query tab.
- create a new query or open an existing one;
-
click the
Execute item of the Navigation bar or use the F9 hot-key to execute the query;
- view/edit the returned data within the Results tab of Query Data.
- create a new query or open an existing one;
- click the Save to file Navigation bar item (in Query data) or the Save SQL Navigation bar item (in Design Query) or use the Ctrl+S shortcut to save the query using the Save as... dialog;
- click the Save diagram Navigation bar item in Design Query to save the designed diagram;
or
- use the Save all Navigation bar item in Query data if you need to save all the queries to one file.
See also: |
|
|