Home » SQL & PL/SQL » Client Tools » what's the best free oracle client tool? (10g, xp)
what's the best free oracle client tool? [message #419987] Wed, 26 August 2009 06:08 Go to next message
kang
Messages: 89
Registered: November 2007
Member
what's the best free oracle client tool?
I want the feature of inplace-update like in pl/sql develper,
"select * from tab for update" -> unlock -> edit -> commit;

preferably I want the client tool prompt the object name when I type the object name like in pl/sql develper.

TIA.
Re: what's the best free oracle client tool? [message #419994 is a reply to message #419987] Wed, 26 August 2009 07:06 Go to previous messageGo to next message
Michel Cadot
Messages: 59203
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For myself, the best one is SQL*Plus, simpy because it requires to be smart and not dumb.

Regards
Michel

[Updated on: Wed, 26 August 2009 07:06]

Report message to a moderator

Re: what's the best free oracle client tool? [message #420015 is a reply to message #419994] Wed, 26 August 2009 09:13 Go to previous messageGo to next message
Frank
Messages: 7877
Registered: March 2000
Senior Member
I myself use PL/SQL Developer, since I can think of better ways to spend my time other than typing out everything instead of using code-completion, macros, etc.
Also, since I am similar to 90% of the people, I find it easier to view query results in a nice GUI-grid then in some ascii version that does not fit my screen.

I heard Oracle's SQL Developer is getting better all the time; not sure though whether it supports in-place editing and code-completion. It is free to download, so give it a try.
Re: what's the best free oracle client tool? [message #420022 is a reply to message #420015] Wed, 26 August 2009 10:36 Go to previous messageGo to next message
andrew again
Messages: 2574
Registered: March 2000
Senior Member
I've used SQL Developer, Rapid SQL and a few others, but keep coming back to the commercial version of Toad as it's more intuative and feature rich (to me). The optional tabbed view in the object browser is no much easier to use when you have a large number of users & objects than the tree contol that the others use.

Free toad is here ==> http://www.toadsoft.com/toad_oracle.htm
SQL developer would be my second choice. sqlplus is great for concise test cases and can be relied to be available in just about any environment.

comparison ==> http://www.orafaq.com/tools/

[Updated on: Wed, 26 August 2009 10:37]

Report message to a moderator

Re: what's the best free oracle client tool? [message #420035 is a reply to message #419987] Wed, 26 August 2009 12:05 Go to previous messageGo to next message
shivster01
Messages: 8
Registered: August 2009
Junior Member
Been using the Oracle SQL Developer for about a month.
It seems like a decent tool.

SQLDBX.com has another decent tool. The Personal(free) edition with its limitations(one db connect and 2 script windows), is quite a feature rich editor.

[Updated on: Wed, 26 August 2009 12:07]

Report message to a moderator

Re: what's the best free oracle client tool? [message #420062 is a reply to message #420022] Wed, 26 August 2009 16:25 Go to previous messageGo to next message
Frank
Messages: 7877
Registered: March 2000
Senior Member
andrew again wrote on Wed, 26 August 2009 17:36
sqlplus is great for concise test cases and can be relied to be available in just about any environment.

Totally true, and I do think that every developer should know how to work with sqlplus and be able to do anything he needs to do using sqlplus.
But once he knows how to do it in sqlplus, it is ok to step up to a GUI based tool
Re: what's the best free oracle client tool? [message #420123 is a reply to message #419987] Thu, 27 August 2009 02:54 Go to previous messageGo to next message
mart
Messages: 3
Registered: August 2009
Junior Member

Sql plus is best
oracle 9i with 10 g..

Re: what's the best free oracle client tool? [message #420127 is a reply to message #420123] Thu, 27 August 2009 03:16 Go to previous messageGo to next message
Frank
Messages: 7877
Registered: March 2000
Senior Member
mart wrote on Thu, 27 August 2009 09:54
Sql plus is best
oracle 9i with 10 g..



Apart from the fact that it does not in any way comply to the requirements of the original poster...
icon14.gif  Re: what's the best free oracle client tool? [message #464684 is a reply to message #420127] Thu, 08 July 2010 14:33 Go to previous messageGo to next message
shivster01
Messages: 8
Registered: August 2009
Junior Member
TOra is a decent tools as well. It tries to be an open source replacement for Toad.
Re: what's the best free oracle client tool? [message #464991 is a reply to message #419987] Mon, 12 July 2010 00:27 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
kang wrote on Wed, 26 August 2009 06:08
what's the best free oracle client tool?
I want the feature of inplace-update like in pl/sql develper,
"select * from tab for update" -> unlock -> edit -> commit;

preferably I want the client tool prompt the object name when I type the object name like in pl/sql develper.

TIA.


SQL Developer

1/ Its FREE.
2/ Provided by Oracle.
3/ Lot of support on Oracle Site.
4/ Oracle keep you posted for latest release.( So you stay updated)

All The Best.
Re: what's the best free oracle client tool? [message #466135 is a reply to message #464991] Sat, 17 July 2010 03:07 Go to previous messageGo to next message
ranamirfan
Messages: 529
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Quote:

what's the best free oracle client tool?
I want the feature of inplace-update like in pl/sql develper,
"select * from tab for update" -> unlock -> edit -> commit;

preferably I want the client tool prompt the object name when I type the object name like in pl/sql develper.

TIA.



I've used Toad but for a few months I m using SQL Developer due to oracle product but keep coming back to the commercial version of Toad. As Myself Toad is best then SQL Developer.
Re: what's the best free oracle client tool? [message #466138 is a reply to message #466135] Sat, 17 July 2010 03:29 Go to previous messageGo to next message
Frank
Messages: 7877
Registered: March 2000
Senior Member
The commercial version of TOAD is not free.
Re: what's the best free oracle client tool? [message #466140 is a reply to message #466138] Sat, 17 July 2010 03:34 Go to previous messageGo to next message
ranamirfan
Messages: 529
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Yes,Mr.Frank you are saying right.
Re: what's the best free oracle client tool? [message #466163 is a reply to message #466140] Sat, 17 July 2010 06:50 Go to previous messageGo to next message
vamsi kasina
Messages: 2096
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
I'm using SQL Developer for years.
I only see difficulty in applying big packages or opening the package code. It is little slow in that.
Also some times with Accelerators. Some keys don't work.
Rest is fine.

By
Vamsi
Re: what's the best free oracle client tool? [message #466945 is a reply to message #466163] Wed, 21 July 2010 13:33 Go to previous message
talek
Messages: 3
Registered: December 2006
Location: Romania, Iasi
Junior Member

If you like VIM and sqlplus you may give VoraX a try. It is available on vim.org official site.
Previous Topic: Run the Oracle sql script from shared mapped drive
Next Topic: Changing a db password using the SQLplus command line
Goto Forum:
  


Current Time: Tue Sep 23 22:27:41 CDT 2014

Total time taken to generate the page: 0.09055 seconds