EMS logo

Products Navigation

SQL Studio for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Management Studio for Oracle

On-line Documentation

First time started


This is how SQL Management Studio for Oracle looks when you start it for the first time. Use the Desktop panel to fulfill any database management task, or start a utility.

 

The main menu allows you to perform various Database operations, activate/deactivate toolbars, Navigation bar panes and tool descriptions within the View menu, access SQL Studio tools in groups using items of the Navigate menu, run any Studio tool using the Run menu, customize the application using the Options menu, access Registration information and product documentation using the corresponding items available within the Help menu.

 

The Navigation bar on the left allows you to switch between the activities in groups:

RadioButton Tools

RadioButton Tasks

RadioButton Internet

 

The main toolbar duplicates items of the Navigation bar and is implemented for quick access to SQL Studio activities.

 

To start working with your Oracle, you should first register the host using Register Host wizard. After that you need to register one or several databases using Register Database Wizard.

 

By default the corresponding RegisterHost Register / UnregisterHost Unregister Host, RegisterDB Register / UnregisterDB Unregister Database, DBRegistrationInfoDatabase Registration Info buttons are available on the toolbar of DB Explorer and within the Database menu.

 

DB Explorer which is located below the Navigation bar displays all registered hosts and databases; you can add and remove items to/from the Explorer tree, browse registration information on hosts and databases and start Oracle services for selected databases. You can also use this database registration information in utilities integrated in SQL Management Studio for Oracle.

 

Getting Started

 

 

When the database connection settings are specified, you can set connection to your database and proceed to Database Management & Manipulation, Scheduling & Performing tasks, and other tools of SQL Studio.

 

 


See also:

Using Studio Agent

Selecting application language

Working with main menu

Working with toolbars

Using Desktop Panel

Using Navigation bar

Using DB Explorer