In this short video I'll help you get started with Toad for Oracle. There are two other videos which accompany this one, both of which are more advanced, one for developers and one for DBAs.Īnd I'll be going through the basic features and functions of the product.

So when you finish watching this, one please choose one or both of those to follow up with. So first I'm going to show you how to log onto the Oracle server using Toad. Then I'll go through some of the key features and functions, some of the main windows, such the Schema Browser and the Editor. I'll show you how to configure Toad by selecting the most appropriate options for you, as well as how to customize the user interface so you can change the look and feel. I'll then show you about the different editions that are available with Toad, so that will help you identify which of the editions that suit the role that you're in. And then I'll close out with where you can find more information about Toad for Oracle, both inside of Toad and outside. And you see here the main menu and the toolbar, with a number of buttons and various slide-out windows, which I'll talk about later on. So let's first make a connection to the server. I'm going to push the Connection button first of all. This is how to make a connection, and open the Connection window. I'll select a user name and password to enter. There are a number of different ways in which you can connect to the server. You can either select a TNS ORA file, we can use a direct connection, or we can use the LDAP interface. With a direct connection, you need to put a host name, and a port number, and a service name. And you can also specify a color that you want to associate with this connection. That helps you differentiate the different windows that you might have open in Toad from one another, particularly if you're connecting to production databases.

Toad for oracle 13 full mega