Look at the overloaded dbms_stats.convert_raw_value()
procedures. (The name may be a little off, I'm working
from memory).
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
April 2004 Iceland
June 2004 UK - Optimising Oracle Seminar
"Rich Gugel" <rich.gugel_at_doa.state.wi.us> wrote in message
news:4999ceb3.0403081013.ce9933f_at_posting.google.com...
> Perhaps this has already been done, but I have not been able to find
> it. I want to display out the values of low-value and high-value
> which are raw data type in a readable format. For example the hire
> date would display as 30-sep-2004 instead of 7865091E010101 Oracle 9i
> by the way. How to I get the following query to display correctly?
>
Received on Mon Mar 15 2004 - 17:19:27 CST
