-
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.
-
SQL> select to_char(106,'XXXXXXXXX') from dual;
TO_CHAR(10
----------
6A
SQL>
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
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>
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|