Ethan,

not sure if it will server your purpose, but check out the ntile() analytic
function.

Quoting Ethan Post <post.ethan@(protected)>:

> I am looking for the easiest way to take a select and transform into some
> sort of histogram...
>
> select numeric_value from table_name;
>
> should come back as
>
> range         total
> 1-10           30
> 11-20         100
> ...
>
--
regards

Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA
Centrex Consulting Corporation
www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l