Home » Other » 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: 68625
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: 7901
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: 2577
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: 7901
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: 7901
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: 535
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: 7901
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: 535
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: 2112
Registered: October 2003
Location: Cincinnati, OH
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 messageGo to next 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.
Re: what's the best free oracle client tool? [message #659615 is a reply to message #466945] Tue, 24 January 2017 06:20 Go to previous messageGo to next message
Alexeyg
Messages: 24
Registered: May 2014
Location: Czech Republic
Junior Member
On my mind the best oracle gui is dbForge Studio for Oracle. The express edition is free of charge.
Re: what's the best free oracle client tool? [message #659618 is a reply to message #659615] Tue, 24 January 2017 08:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And the fact you produce this one has nothing with the "best" qualifier. Laughing

Re: what's the best free oracle client tool? [message #659917 is a reply to message #420015] Fri, 03 February 2017 10:21 Go to previous messageGo to next message
thatjeffsmith
Messages: 81
Registered: July 2009
Location: Raleigh, NC
Member

>> not sure though whether it supports in-place editing and code-completion. It is free to download, so give it a try.
in-place editing....of the results of a query?
NO.

Code-completion
Yes, and lots of it.


And if you like the idea of SQL*Plus but miss some modern things like code completion or ability to type, backspace, edit at the prompt w/o jumping out to emacs/vi - then try out SQLcl.

Best is always a funny word...only you can decide what works best for you.
Re: what's the best free oracle client tool? [message #660985 is a reply to message #659917] Thu, 02 March 2017 23:31 Go to previous message
oraclesree
Messages: 1
Registered: March 2017
Location: Hyderabad,India
Junior Member

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 control that the others use.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.
Previous Topic: Unable to get sql buffer facility
Next Topic: [oracle 10g] ora-27101 shared memory realm does not exist windows xp
Goto Forum:
  


Current Time: Thu Mar 28 14:52:05 CDT 2024