Re: Reading and converting ALL_TAB_COL_STATISTICS

From: Martin Berger <>
Date: Mon, 9 Nov 2009 15:27:58 +0100
Message-ID: <>


have you checked Martin Widlake's blog, especially this entry:

maybe this is a good starting-point.


On Mon, Nov 9, 2009 at 15:22, Martin Klier <> wrote:
> Dear list,
> how can I convert the raw(32)  columns LOW_VALUE and HIGH_VALUE of
> ALL_TAB_COL_STATISTICS to their decimal value? TO_NUMBER(rawtohex
> (high_value),'XXXXXXXX') gives me not the value I expect (stats are recent)
> and in the table min(id) is 1 and max(id) is 8 million). DUMPing the values
> (see last part of the SQL below) does not give me any better idea....

Received on Mon Nov 09 2009 - 08:27:58 CST

Original text of this message