Visual Query tools for Oracle?

#1

Well, I just lost another 2 hours this morning trying to find a visual
query tool for Oracle that has reasonable performance and user
friendliness.
I tested FlySpeed SQL Query (freeware), Maestro Oracle code factory
(trial) and my standard tool Toad 9 (commercial product).
In my opinion none of the three does a good job. The first two make a
ridicolous use of memory that makes them totally unusable with large
databases.
Toad is much better at that, but the interface to create and execute
queries using the "Query Builder" tool is a pain in the neck.

Is it possible that a good visual query tool for Oracle just doesn't
exist? Don't tell me that real professionals don't use graphic tools,
I have been designing database applications for 30 years but I still
appreciate the speed of a good graphical interface.

Any suggestions about existing tools are welcome, but please make sure
that they are capable of working with large databases (hundred of
tables and terabytes of data).

Andrea

#2

<anvi777 (AT) gmail (DOT) com> wrote

Quote:

Well, I just lost another 2 hours this morning trying to find a visual
query tool for Oracle that has reasonable performance and user
friendliness.
I tested FlySpeed SQL Query (freeware), Maestro Oracle code factory
(trial) and my standard tool Toad 9 (commercial product).
In my opinion none of the three does a good job. The first two make a
ridicolous use of memory that makes them totally unusable with large
databases.
Toad is much better at that, but the interface to create and execute
queries using the "Query Builder" tool is a pain in the neck.

Is it possible that a good visual query tool for Oracle just doesn't
exist? Don't tell me that real professionals don't use graphic tools,
I have been designing database applications for 30 years but I still
appreciate the speed of a good graphical interface.

Any suggestions about existing tools are welcome, but please make sure
that they are capable of working with large databases (hundred of
tables and terabytes of data).

Andrea

PLSQLDeveloper.
Alternatively, you could use a report writer like Sybase InfoMaker. It has
the best graphical query painter of any tool I've ever used.
--
Terry Dykstra

#3

<anvi777 (AT) gmail (DOT) com> wrote

Quote:

Well, I just lost another 2 hours this morning trying to find a visual
query tool for Oracle that has reasonable performance and user
friendliness.
I tested FlySpeed SQL Query (freeware), Maestro Oracle code factory
(trial) and my standard tool Toad 9 (commercial product).
In my opinion none of the three does a good job. The first two make a
ridicolous use of memory that makes them totally unusable with large
databases.
Toad is much better at that, but the interface to create and execute
queries using the "Query Builder" tool is a pain in the neck.

Is it possible that a good visual query tool for Oracle just doesn't
exist? Don't tell me that real professionals don't use graphic tools,
I have been designing database applications for 30 years but I still
appreciate the speed of a good graphical interface.

Any suggestions about existing tools are welcome, but please make sure
that they are capable of working with large databases (hundred of
tables and terabytes of data).

Andrea

PLSQLDeveloper.
Alternatively, you could use a report writer like Sybase InfoMaker. It has
the best graphical query painter of any tool I've ever used.
--
Terry Dykstra

#4

<anvi777 (AT) gmail (DOT) com> wrote

Quote:

Well, I just lost another 2 hours this morning trying to find a visual
query tool for Oracle that has reasonable performance and user
friendliness.
I tested FlySpeed SQL Query (freeware), Maestro Oracle code factory
(trial) and my standard tool Toad 9 (commercial product).
In my opinion none of the three does a good job. The first two make a
ridicolous use of memory that makes them totally unusable with large
databases.
Toad is much better at that, but the interface to create and execute
queries using the "Query Builder" tool is a pain in the neck.

Is it possible that a good visual query tool for Oracle just doesn't
exist? Don't tell me that real professionals don't use graphic tools,
I have been designing database applications for 30 years but I still
appreciate the speed of a good graphical interface.

Any suggestions about existing tools are welcome, but please make sure
that they are capable of working with large databases (hundred of
tables and terabytes of data).

Andrea

PLSQLDeveloper.
Alternatively, you could use a report writer like Sybase InfoMaker. It has
the best graphical query painter of any tool I've ever used.
--
Terry Dykstra

#5

<anvi777 (AT) gmail (DOT) com> wrote

Quote:

Well, I just lost another 2 hours this morning trying to find a visual
query tool for Oracle that has reasonable performance and user
friendliness.
I tested FlySpeed SQL Query (freeware), Maestro Oracle code factory
(trial) and my standard tool Toad 9 (commercial product).
In my opinion none of the three does a good job. The first two make a
ridicolous use of memory that makes them totally unusable with large
databases.
Toad is much better at that, but the interface to create and execute
queries using the "Query Builder" tool is a pain in the neck.

Is it possible that a good visual query tool for Oracle just doesn't
exist? Don't tell me that real professionals don't use graphic tools,
I have been designing database applications for 30 years but I still
appreciate the speed of a good graphical interface.

Any suggestions about existing tools are welcome, but please make sure
that they are capable of working with large databases (hundred of
tables and terabytes of data).

Andrea

PLSQLDeveloper.
Alternatively, you could use a report writer like Sybase InfoMaker. It has
the best graphical query painter of any tool I've ever used.
--
Terry Dykstra

#6

On 17 mar, 12:28, anvi... (AT) gmail (DOT) com wrote:

Quote:

Well, I just lost another 2 hours this morning trying to find a visual
query tool for Oracle that has reasonable performance and user
friendliness.
I tested FlySpeed SQL Query (freeware), Maestro Oracle code factory
(trial) and my standard tool Toad 9 (commercial product).
In my opinion none of the three does a good job. The first two make a
ridicolous use of memory that makes them totally unusable with large
databases.
Toad is much better at that, but the interface to create and execute
queries using the "Query Builder" tool is a pain in the neck.

Is it possible that a good visual query tool for Oracle just doesn't
exist? Don't tell me that real professionals don't use graphic tools,
I have been designing database applications for 30 years but I still
appreciate the speed of a good graphical interface.

Any suggestions about existing tools are welcome, but please make sure
that they are capable of working with large databases (hundred of
tables and terabytes of data).

Andrea

Have you given a try to the chart functionality of Oracle Apex?

#7

On 17 mar, 12:28, anvi... (AT) gmail (DOT) com wrote:

Quote:

Well, I just lost another 2 hours this morning trying to find a visual
query tool for Oracle that has reasonable performance and user
friendliness.
I tested FlySpeed SQL Query (freeware), Maestro Oracle code factory
(trial) and my standard tool Toad 9 (commercial product).
In my opinion none of the three does a good job. The first two make a
ridicolous use of memory that makes them totally unusable with large
databases.
Toad is much better at that, but the interface to create and execute
queries using the "Query Builder" tool is a pain in the neck.

Is it possible that a good visual query tool for Oracle just doesn't
exist? Don't tell me that real professionals don't use graphic tools,
I have been designing database applications for 30 years but I still
appreciate the speed of a good graphical interface.

Any suggestions about existing tools are welcome, but please make sure
that they are capable of working with large databases (hundred of
tables and terabytes of data).

Andrea

Have you given a try to the chart functionality of Oracle Apex?

#8

On 17 mar, 12:28, anvi... (AT) gmail (DOT) com wrote:

Quote:

Well, I just lost another 2 hours this morning trying to find a visual
query tool for Oracle that has reasonable performance and user
friendliness.
I tested FlySpeed SQL Query (freeware), Maestro Oracle code factory
(trial) and my standard tool Toad 9 (commercial product).
In my opinion none of the three does a good job. The first two make a
ridicolous use of memory that makes them totally unusable with large
databases.
Toad is much better at that, but the interface to create and execute
queries using the "Query Builder" tool is a pain in the neck.

Is it possible that a good visual query tool for Oracle just doesn't
exist? Don't tell me that real professionals don't use graphic tools,
I have been designing database applications for 30 years but I still
appreciate the speed of a good graphical interface.

Any suggestions about existing tools are welcome, but please make sure
that they are capable of working with large databases (hundred of
tables and terabytes of data).

Andrea

Have you given a try to the chart functionality of Oracle Apex?

#9

On 17 mar, 12:28, anvi... (AT) gmail (DOT) com wrote:

Quote:

Well, I just lost another 2 hours this morning trying to find a visual
query tool for Oracle that has reasonable performance and user
friendliness.
I tested FlySpeed SQL Query (freeware), Maestro Oracle code factory
(trial) and my standard tool Toad 9 (commercial product).
In my opinion none of the three does a good job. The first two make a
ridicolous use of memory that makes them totally unusable with large
databases.
Toad is much better at that, but the interface to create and execute
queries using the "Query Builder" tool is a pain in the neck.

Is it possible that a good visual query tool for Oracle just doesn't
exist? Don't tell me that real professionals don't use graphic tools,
I have been designing database applications for 30 years but I still
appreciate the speed of a good graphical interface.

Any suggestions about existing tools are welcome, but please make sure
that they are capable of working with large databases (hundred of
tables and terabytes of data).

Andrea

Have you given a try to the chart functionality of Oracle Apex?

#10

On Mar 17, 2:31*pm, vitalis... (AT) gmail (DOT) com wrote:

Quote:

On 17 mar, 12:28, anvi... (AT) gmail (DOT) com wrote:

Well, I just lost another 2 hours this morning trying to find a visual
query tool for Oracle that has reasonable performance and user
friendliness.
I tested FlySpeed SQL Query (freeware), Maestro Oracle code factory
(trial) and my standard tool Toad 9 (commercial product).
In my opinion none of the three does a good job. The first two make a
ridicolous use of memory that makes them totally unusable with large
databases.
Toad is much better at that, but the interface to create and execute
queries using the "Query Builder" tool is a pain in the neck.

Is it possible that a good visual query tool for Oracle just doesn't
exist? Don't tell me that real professionals don't use graphic tools,
I have been designing database applications for 30 years but I still
appreciate the speed of a good graphical interface.

Any suggestions about existing tools are welcome, but please make sure
that they are capable of working with large databases (hundred of
tables and terabytes of data).

Andrea

Have you given a try to the chart functionality of Oracle Apex?- Hide quoted text -

- Show quoted text -

I like SQLDeveloper.

It's free from Oracle, and works in both Windows and *nix
environments. (I've used it in both XP and Centos4.5(RH4.5 clone).
Also correctly handles nested cursor information, sqlnavigator
couldn't do that.

HTH.
Roger Gorden Sr. DBA John Wiley and Sons.