Re: Visual Query tools for Oracle?
Date: Wed, 19 Mar 2008 13:57:47 -0700 (PDT)
On 19 mar, 19:52, Jim Smith <usene..._at_ponder-stibbons.com> wrote:
> In message
> 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.
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