Quality Obsessed

Toad is rather very simple to use, the only place where it can get difficult is while configuring it.

You should specify the database details in the tnsnames.ora file located in the location

Oracle\product\10.1.0\Client_1\NETWORK\ADMIN

if the file is not there create one.

a sample tns file:

SampleDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 10.67.101.14)
(PORT = 1523))
)
(CONNECT_DATA =
(SERVICE_NAME = SampleDB )
)
)

only then it will show up in the UI.

you can also use the TNSEditor that comes with TOAD.

Also you should have an Oracle client installed to use toad.

{Hint: if you want to select multiple rows, right click a row and select 'Multi-select'}