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 Binary Numbers in SQL Statements
How To Enter Binary Numbers in SQL Statements? - MySQL FAQs - Introduction to SQL Basics
✍: FYIcenter.com
If you want to enter character strings or numeric values as binary numbers, you can quote binary numbers with single quotes and a prefix of (B), or just prefix binary numbers with (0b). Binary numbers will be automatically converted into character strings or numeric values based on the expression contexts. Here are some good examples:
SELECT B'010000010100001001000011' FROM DUAL; ABC SELECT 0b1000 + 0 FROM DUAL; 8
2007-05-11, 10126👍, 0💬
Popular Posts:
Can you explain the fundamentals of “GetGlobalResourceObject ”and “GetLocalResourceObject” function...
What is Service Oriented architecture? “Services” are components which expose well defined interface...
How do you locate the first X in a string txt? A) txt.find('X'); B) txt.locate('X'); C) txt.indexOf(...
How do we assign page specific attributes ? Page attributes are specified using the @Page directive.
What is the difference between include directive & jsp:include action? Difference between includ...