OraFAQ Forum: Client Tools » what's the best free oracle client tool?

Home » Other » Client Tools » what's the best free oracle client tool? (10g, xp)

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

what's the best free oracle client tool? [message #419987]

Wed, 26 August 2009 06:08

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.

Report message to a moderator

Re: what's the best free oracle client tool? [message #419994 is a reply to message #419987]

Wed, 26 August 2009 07:06

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

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.

Report message to a moderator

Re: what's the best free oracle client tool? [message #420022 is a reply to message #420015]

Wed, 26 August 2009 10:36

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

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

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

Report message to a moderator

Re: what's the best free oracle client tool? [message #420123 is a reply to message #419987]

Thu, 27 August 2009 02:54

mart
Messages: 3
Registered: August 2009

Junior Member

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

Report message to a moderator

Re: what's the best free oracle client tool? [message #420127 is a reply to message #420123]

Thu, 27 August 2009 03:16

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...

Report message to a moderator

Re: what's the best free oracle client tool? [message #464684 is a reply to message #420127]

Thu, 08 July 2010 14:33

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.

Report message to a moderator

Re: what's the best free oracle client tool? [message #464991 is a reply to message #419987]

Mon, 12 July 2010 00:27

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.

Report message to a moderator

Re: what's the best free oracle client tool? [message #466135 is a reply to message #464991]

Sat, 17 July 2010 03:07

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

ranamirfan@gmail.com

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.

Report message to a moderator

Re: what's the best free oracle client tool? [message #466138 is a reply to message #466135]

Sat, 17 July 2010 03:29

Frank
Messages: 7901
Registered: March 2000

Senior Member

The commercial version of TOAD is not free.

Report message to a moderator

Re: what's the best free oracle client tool? [message #466140 is a reply to message #466138]

Sat, 17 July 2010 03:34

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

ranamirfan@gmail.com

Yes,Mr.Frank you are saying right.

Report message to a moderator

Re: what's the best free oracle client tool? [message #466163 is a reply to message #466140]

Sat, 17 July 2010 06:50

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

Report message to a moderator

Re: what's the best free oracle client tool? [message #466945 is a reply to message #466163]

Wed, 21 July 2010 13:33

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.

Report message to a moderator

Re: what's the best free oracle client tool? [message #659615 is a reply to message #466945]

Tue, 24 January 2017 06:20

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.

Report message to a moderator

Re: what's the best free oracle client tool? [message #659618 is a reply to message #659615]

Tue, 24 January 2017 08:01

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Laughing

Report message to a moderator

Re: what's the best free oracle client tool? [message #659917 is a reply to message #420015]

Fri, 03 February 2017 10:21

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.

Report message to a moderator

Re: what's the best free oracle client tool? [message #660985 is a reply to message #659917]

Thu, 02 March 2017 23:31

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.

Report message to a moderator

Previous Topic:	Unable to get sql buffer facility
Next Topic:	[oracle 10g] ora-27101 shared memory realm does not exist windows xp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 14:33:01 CST 2025