How To Enter Numeric Values As HEX Numbers

How To Enter Numeric Values As HEX Numbers


  • 29 Feb, 2012

    If you want to enter numeric values as HEX numbers, you can quote HEX numbers with single quotes and a prefix of (X), or just prefix HEX numbers with (0x). A HEX number string will be automatically converted into a numeric value, if the expression context is a numeric value. Here are some good examples:SELECT X'10' + 16 FROM DUAL; 32SELECT 0x1000 + 0 FROM DUAL; 4096

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.