Re: Visual Query tools for Oracle?

On Mar 17, 2:31 pm, vitalis..._at_gmail.com wrote:
> On 17 mar, 12:28, anvi..._at_gmail.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. Received on Tue Mar 18 2008 - 13:45:23 CDT