regarding toad and sql developer

[khushi jainy]

hello all,
i want to know about toad and sql developer,
these are the retriving tools for the information that is saved in database??
can i have toad on one system and can retrive information from database which is on another system.
if it is possible please suggest me how can i remotely access database.
Please guide me regarding this.

Thank You.

[Jan Cumps]

Originally posted by khushi jainy:
can i have toad on one system and can retrive information from database which is on another system.

Yes.


if it is possible please suggest me how can i remotely access database.
Please guide me regarding this.
First you have to install Oracle SQL client software on the TOAD computer.
Then you have to create a TNS entry for your remote database on that same TOAD computer. Toad's logon form has an SQLnet and TNSnames editor.

Then you have to connect to that same TNS entry on Toad's logon form.