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, 9917👍, 0💬
Popular Posts:
If client side validation is enabled in your Web page, does that mean server side code is not run? W...
How To Run a JUnit Test Class? A JUnit test class usually contains a number of test methods. You can...
How To Use Subqueries with the IN Operator? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqu...
How To Run a JUnit Test Class? A JUnit test class usually contains a number of test methods. You can...
How did you implement UML in your project ? PART II Implementation phase / Coding phase (Class diagr...