Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to get column high_value and low_value?

Re: How to get column high_value and low_value?

From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Wed, 17 Oct 2007 23:10:33 +0200
Message-ID: <47167A49.8090704@roughsea.com>


Brandon,

This script does it:
http://www.roughsea.com/article.php3?id_article=60

Allen, Brandon 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
>
>
> Privileged/Confidential Information may be contained in this message
> or attachments hereto. Please advise immediately if you or your
> employer do not consent to Internet email for messages of this kind.
> Opinions, conclusions and other information in this message that do
> not relate to the official business of this company shall be
> understood as neither given nor endorsed by it.
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 17 2007 - 16:10:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US