Online Documentation for SQL Query for Oracle

Query management tools


When using SQL Query for Oracle, you are provided with two basic tools you may need to manage your SQL queries: SQL Editor for editing  SQL query text directly and Visual Query Builder for building queries visually. Find the list of common SQL query management operations below.

 

Creating new queries

In order to create a new query in SQL Query for Oracle:

  • select the Query | New Query main menu item or use the corresponding btnNewQuery toolbar button;
  • specify a name for the new query within the New Query dialog;
  • proceed to the Edit tab and use SQL Editor to edit the SQL query text

or

 

Editing queries

In order to open a query in SQL Query for Oracle:

  • select the query in the DB Explorer tree;
  • right-click the query and select the Activate Query context menu item

or

 

In order to load a query from an *.sql file:

  • select the Query | Load... main menu item or use the corresponding btnLoadQuery toolbar button;
  • specify the query file within the Load SQL File dialog.

 

Executing queries

In order to execute a query in SQL Query for Oracle:

  • create a new query or open an existing one;
  • select the Query | Execute main menu item or use the corresponding iconExecuteQuery toolbar button

or

  • use the F9 hot-key to execute the query.

 

Saving queries

In order to save a query in SQL Query for Oracle:

  • create a new query or open an existing one;
  • select the Query | Save... or the Query | Save as... main menu item

or

  • use the Ctrl+S shortcut to save the query

or

  • use the Query | Save all queries main menu item if you need to save all the queries at a time.