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: Greg Rahn <greg_at_structureddata.org>
Date: Tue, 16 Oct 2007 19:44:19 -0700
Message-ID: <a9c093440710161944l7265baadi6fdecba15fb04e6e@mail.gmail.com>


Here is a blog post with the code. Enjoy!

http://structureddata.org/2007/10/16/how-to-display-high_valuelow_value-columns-from-user_tab_col_statistics/

On 10/16/07, Greg Rahn <greg_at_structureddata.org> wrote:
> 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.

-- 
Regards,

Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 16 2007 - 21:44:19 CDT

Original text of this message

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