Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Converting hex to number & date

SweAnderlineNov 14 2008 — edited Nov 20 2008
Hi!

Im having a problem converting the hex code to the number & date.

select low_value,high_value from ALL_TAB_COL_STATISTICS;

Iv tried HEX_TO_CHAR and that works fine.

select column_name, UTL_I18N.RAW_TO_CHAR(low_value),UTL_I18N.RAW_TO_CHAR(high_value),low_value, UTL_I18N.RAW_TO_CHAR(high_value) from ALL_TAB_COL_STATISTICS where owner = 'user' and table_name = 'table_name';

if you type this statement you will see that numeric fields and date fields get caught up in (¿) type of fields.

Any solution for this?

BR / S-A

Edited by: SweAnderline on 2008-nov-14 12:58
This post has been answered by 450441 on Nov 14 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 18 2008
Added on Nov 14 2008
7 comments
917 views