Re: Visual Query tools for Oracle?

On 19 mar, 19:52, Jim Smith <usene..._at_ponder-stibbons.com> wrote:
> In message
> <856b37d2-002a-4ed0-9985-708d8a069..._at_q78g2000hsh.googlegroups.com>,
> vitalis..._at_gmail.com writes

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

Thanks Jim.
You're right, it works with "select object_type,object_type,count(*) from
all_objects group by object_type,object_type having count(*)>500" !! Received on Wed Mar 19 2008 - 15:57:47 CDT