OraFAQ Forum: Client Tools » Doubts on TOAD and SQL developer

Home » Other » Client Tools » Doubts on TOAD and SQL developer

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Doubts on TOAD and SQL developer [message #474867]

Thu, 09 September 2010 07:20

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Hi,

Can somebody clarify my doubts on TOAD and SQL developer ?

Can toad be connected to oracle server without Tnsnames.ora file and oracle software installed ?

Can SQL developer be connected to oracle server without Tnsnames.ora file and oracle software installed ?

Thanks

Report message to a moderator

Re: Doubts on TOAD and SQL developer [message #474874 is a reply to message #474867]

Thu, 09 September 2010 08:07

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

1) Yes, with TOAD, you can use "Connect Direct", but you do need the Oracle client installed

2) Yes, the same with SQL developer

[Updated on: Thu, 09 September 2010 08:18] by Moderator

Report message to a moderator

Re: Doubts on TOAD and SQL developer [message #474946 is a reply to message #474874]

Fri, 10 September 2010 00:29

Frank
Messages: 7901
Registered: March 2000

Senior Member

Are you sure that SQL Developer needs the Oracle client software? I thought it uses jdbc, so there is no need for an OCI

Report message to a moderator

Re: Doubts on TOAD and SQL developer [message #474963 is a reply to message #474946]

Fri, 10 September 2010 06:57

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Frank wrote on Fri, 10 September 2010 06:29

Are you sure that SQL Developer needs the Oracle client software? I thought it uses jdbc, so there is no need for an OCI

Definitely doesnt, loads of guys in my place have it but not many have client.

Report message to a moderator

Previous Topic:	sql*plus
Next Topic:	EXCEL preventing large numbers being displayed in scientific notation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 21:33:58 CST 2025