Hi, I want to convert decimal to hexa for hexa being as large as upto 32 digits.How can i do this.This means my decimal will be more bigger.I know how to convert from dec to hex but how can it be done for such large value. Thanks, Nishant.
Nishant Manchanda
SQL> select to_char(106,'XXXXXXXXX') from dual; TO_CHAR(10 ---------- 6A SQL>
Oracle Certified Master Oracle Certified Professional 6i,8i,9i,10g,11g email: ocp_9i@yahoo.com
Thanks !! If i want hexa back to that big number ? Take care, Nishant
The other way around: Code: SQL> select to_number('F','XXXXXXXXX') from dual; TO_NUMBER('F','XXXXXXXXX') -------------------------- 15 SQL>
SQL> select to_number('F','XXXXXXXXX') from dual; TO_NUMBER('F','XXXXXXXXX') -------------------------- 15 SQL>
Forum Rules
Bookmarks