Online Documentation for SQL Query for Oracle

Database management tools


SQL Query for Oracle provides a number of tools you may need to manage your Oracle databases. Find the list of common database management operations for working in SQL Query below.

 

 

Registering Databases

In order to register a single database in SQL Query for Oracle:

  • select the Database | Register Database... main menu item or use the corresponding btnRegisterDB toolbar button;
  • set all the necessary options using Register Database Wizard which guides you through the whole process of Database registration.

 

 

Unregistering Databases

In order to unregister a single database in SQL Query for Oracle:

  • select the database to unregister in the DB Explorer tree;
  • select the Database | Unregister Database main menu item or use the corresponding btnUnregisterDB toolbar button;
  • confirm unregistering in the corresponding dialog window.

 

Connecting to Databases

In order to connect to a database in SQL Query for Oracle:

  • select the database to connect to in the DB Explorer tree;
  • double-click its alias

or

  • select the Database | Connect to Database main menu item or use the corresponding btnConnectToDB toolbar button

or

  • right-click its alias and select the Connect to Database context menu item.

 

Disconnecting from Databases

In order to disconnect from a database in SQL Query for Oracle:

  • select the alias of the database to disconnect from or any of its objects in the DB Explorer tree;
  • select the Database | Disconnect from Database main menu item or use the corresponding btnDisconnectFromDB toolbar button

or

  • right-click its alias or any of its objects and select the Disconnect from Database context menu item.