DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: decimal to hexa

  1. #1
    Join Date
    Feb 2002
    Location
    Dallas , Texas
    Posts
    158
    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.

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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

  3. #3
    Join Date
    Feb 2002
    Location
    Dallas , Texas
    Posts
    158
    Thanks !!
    If i want hexa back to that big number ?
    Take care,
    Nishant

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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
  •  


Click Here to Expand Forum to Full Width