Oracle Databases - Standard query tool

Author

Standard query tool

Jeroen Gouma

2005-08-05, 3:25 am

Hi,

what is the 'de facto' query-tool for Oracle?

Requirements: Objectbrowser, should be able to export query-results to
file, save query's, load query's from txt-file.

As DBA I'm really amused from TOAD, but is this the right thing to
give to user who just have to crate and run query's on the database?
In my opinion TOAD is a lot overkill, but is there an alternative out
there?

Thanks,

Jeroen

Matthias Hoys

2005-08-05, 9:25 am

"Jeroen Gouma" <Jeroen@somewhere.else> wrote in message
news:gh36f1557ev68ue
lvtitbq1jrl8e8ro60p@
4ax.com...
> Hi,
>
> what is the 'de facto' query-tool for Oracle?
>
> Requirements: Objectbrowser, should be able to export query-results to
> file, save query's, load query's from txt-file.
>
> As DBA I'm really amused from TOAD, but is this the right thing to
> give to user who just have to crate and run query's on the database?
> In my opinion TOAD is a lot overkill, but is there an alternative out
> there?
>
>
> Thanks,
>
> Jeroen

The de-facto tool is called sqlplus. Really ;-)
I prefer TOAD as a third-party tool (above SQL Navigator), it's true that
it's expensive but there are also freeware and read-only versions.

Matthias

HansF

2005-08-05, 8:25 pm

On Fri, 05 Aug 2005 09:01:59 +0200, Jeroen Gouma interested us by writing:

> Hi,
>
> what is the 'de facto' query-tool for Oracle?
>
> Requirements: Objectbrowser, should be able to export query-results to
> file, save query's, load query's from txt-file.
>
> As DBA I'm really amused from TOAD, but is this the right thing to
> give to user who just have to crate and run query's on the database?
> In my opinion TOAD is a lot overkill, but is there an alternative out
> there?

IMO, there is no 'standard' or 'de facto' query tool. There is a plethora
of tools to fulfil all the various niches that people percieve as being
necessary.

Yet another list .... starting with the ones from Oracle ...

1) SQLPlus - a command line oriented query and administration tool.
Advantage - included with database.

2) iSQLPlus - derived from SQLPlus, operates using a browser and
therefore does not need Oracle-specific software loaded on client machine.
Also included with database.

3) Oracle Enterprise Manager - has a primitive data access tool that is
useful for quick access, especially when doing basic administration. Also
included with database.

4) Oracle JDeveloper - has a decent query tool, especially useful for
developers.

5) Oracle Discoverer - full ad-hoc query tool. Can save queries, can
publish queries to Oracle Reports, to email, to paper, to web, etc.
Part of Oracle's Developer Suite and deployed through Oracle's App
server. Once won an award for user interface. This is a candidate to
fulfil the niche implied in the question.

(Please add on - if it's a list, it ain't spam, right? <g> )

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***

Jack Miller

2005-08-25, 8:26 pm

Try WinSQL http://www.synametrics.com/winsql

Jeroen Gouma wrote:
> Hi,
>
> what is the 'de facto' query-tool for Oracle?
>
> Requirements: Objectbrowser, should be able to export query-results to
> file, save query's, load query's from txt-file.
>
> As DBA I'm really amused from TOAD, but is this the right thing to
> give to user who just have to crate and run query's on the database?
> In my opinion TOAD is a lot overkill, but is there an alternative out
> there?
>
>
> Thanks,
>
> Jeroen

Sponsored Links