Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Enter Numeric Values as HEX Numbers
How To Enter Numeric Values as HEX Numbers? - MySQL FAQs - Introduction to SQL Basics
✍: FYIcenter.com
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; 32 SELECT 0x1000 + 0 FROM DUAL; 4096
2007-05-11, 8974👍, 0💬
Popular Posts:
How To List All Values of Submitted Fields? - PHP Script Tips - Processing Web Forms If you want lis...
How can you raise custom errors from stored procedure ? The RAISERROR statement is used to produce a...
What is difference between Association, Aggregation and Inheritance relationships? In object oriente...
How comfortable are you with writing HTML documents entirely by hand? Everyone has a different prefe...
Which is the best place to store ConnectionString in Dot Net Projects? I am about to deploy my first...