X-FeedAbuse: http://nntpfeed.proxad.net/abuse.pl feeded by 88.191.65.235 Path: text.usenetserver.com!out02a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!nntpfeed.proxad.net!news.side3.eu!dedekind.zen.co.uk!zen.net.uk!demorgan.zen.co.uk!prichard.zen.co.uk.POSTED!not-for-mail Message-ID: Date: Wed, 19 Mar 2008 18:52:25 +0000 From: Jim Smith Newsgroups: comp.databases.oracle.misc Subject: Re: Visual Query tools for Oracle? References: <289b57cd-6c9c-4b56-953e-2d21f7149c53@t54g2000hsg.googlegroups.com> <37fe87f8-92f1-4d87-9289-d6b0df359039@u10g2000prn.googlegroups.com> <3311d50e-821e-4764-b6e4-c281331c72cc@2g2000hsn.googlegroups.com> <856b37d2-002a-4ed0-9985-708d8a0692d1@q78g2000hsh.googlegroups.com> Organization: Ponder Stibbons Limited MIME-Version: 1.0 Content-Type: text/plain;charset=us-ascii;format=flowed User-Agent: Turnpike/6.07-M () Lines: 64 NNTP-Posting-Host: 72e60923.news.zen.co.uk X-Trace: DXC=9EI2b52Zgg858V:0g@SS;SF6n7Wf`c0OWD]VlR173HQFJcd4E; X-Complaints-To: abuse@zen.co.uk Xref: usenetserver.com comp.databases.oracle.misc:252164 X-Received-Date: Wed, 19 Mar 2008 13:57:01 EST (text.usenetserver.com) In message <856b37d2-002a-4ed0-9985-708d8a0692d1@q78g2000hsh.googlegroups.com>, vitalisman@gmail.com writes >On Mar 18, 7:45 pm, "rogergor...@gmail.com" >wrote: >> On Mar 17, 2:31 pm, vitalis...@gmail.com wrote: >> >> >> >> > On 17 mar, 12:28, anvi...@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. > >Thanks for the tip, Roger. I hadn't paid much attention to the chart >report functionality of SQL Developer so far. > >I've just tried to draw a chart for "select object_type,count(*) from >all_objects group by object_type having count(*)>500" with chart type >"BAR_VERT_CLUST" but I just get a blank chart with the ojbect types at >the bottom, the counts in a margin with associated colors, but no >colored bars at all. > >Any idea? I'm ashamed but I have to admit that I haven't really read >the f* manual. ;-) Well you could try reading the manual, but there isn't anything useful. SQLDeveloper charts are pretty but limited. For some reason you have to have three columns. Look at the object distribution report provided for an example. -- Jim Smith