Home » SQL & PL/SQL » Client Tools » Doubts on TOAD and SQL developer
Doubts on TOAD and SQL developer [message #474867] Thu, 09 September 2010 07:20 Go to next message
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
Re: Doubts on TOAD and SQL developer [message #474874 is a reply to message #474867] Thu, 09 September 2010 08:07 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 449
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 Go to previous messageGo to next message
Frank
Messages: 7880
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
Re: Doubts on TOAD and SQL developer [message #474963 is a reply to message #474946] Fri, 10 September 2010 06:57 Go to previous message
Roachcoach
Messages: 1233
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.
Previous Topic: sql*plus
Next Topic: EXCEL preventing large numbers being displayed in scientific notation
Goto Forum:
  


Current Time: Sat Dec 20 02:12:36 CST 2014

Total time taken to generate the page: 0.06464 seconds