EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

On-line Documentation

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.

 

Creating New Queries

In order to create a new query in Query data editor:

  • select the Tools | Query data main menu item or use the corresponding btnNewSQLEditor 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 btnNewQueryBuilder toolbar button;
  • build the query visually within the Builder tab.

 

Editing Queries

In order to open a query in Query data editor:

  • select the Tools | Query Data main menu item or use the corresponding btnShowSQLEditor 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 btnShowQueryBuilder 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 btnNewSQLEditor 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.

 

Executing Queries

  • create a new query or open an existing one;
  • click the btnExecuteQuery 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.

 

Saving Queries

  • 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

 


See also:

Getting Started

Database Explorer

Database Management

Database Objects Management

Data Management

Import/Export Tools

Database Tools

Services

Options

How To...