Re: How to get column high_value and low_value?

You can use dbms_stats.convert_raw_value(). It's probably easiest to wrap this with a function that takes the column and a data type as a string so you can use it directly on your select.

On 10/16/07, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
>
>
> I've googled and metalinked all the key words I can think of and can't find
> any way to extract the actual high and low values for a column since the
> values given in dba_tab_col_statistics are in an internal, raw format.
>
> Can anyone please tell me how to get the number or string values?
>
> I know I can get them out of a 10053 trace file, but I'm hoping there's an
> easier way.
>
> Thanks,
> Brandon

-- 
Regards,

Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l