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

"Jeroen Gouma" <Jeroen (AT) somewhere (DOT) else> wrote

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

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

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

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



Jeroen Gouma wrote: