Re: How to get column high_value and low_value?
- From: "Greg Rahn" <greg@xxxxxxxxxxxxxxxxxx>
- To: Brandon.Allen@xxxxxxxxxxx
- Date: Tue, 16 Oct 2007 18:58:31 -0700
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@xxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
