How To Enter Numeric Values as HEX Numbers?
Submitted by: AdministratorIf 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;
32
SELECT 0x1000 + 0 FROM DUAL;
4096
Submitted by: Administrator
SELECT X'10' + 16 FROM DUAL;
32
SELECT 0x1000 + 0 FROM DUAL;
4096
Submitted by: Administrator
Read Online MySQL Programming Job Interview Questions And Answers
Top MySQL Programming Questions
| ☺ | What Is TIMESTAMP in MySQL? |
| ☺ | How To Use Regular Expression in Pattern Match Conditions? |
| ☺ | How To Decrement Dates by 1 in MySQL? |
| ☺ | How To Use CASE Expression? |
| ☺ | How To Delete an Existing Column in a Table? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
| ☺ | Sybase Interview Questions. |
