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 Use IN Conditions
How To Use IN Conditions? - Oracle DBA FAQ - Understanding SQL Basics
✍: FYIcenter.com
An IN condition is single value again a list of values. It returns TRUE, if the specified value is in the list. Otherwise, it returns FALSE.
Some examples are given in the script below:SELECT CASE WHEN 3 IN (1,2,3,5) THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; TRUE SELECT CASE WHEN 3 NOT IN (1,2,3,5) THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; FALSE SELECT CASE WHEN 'Y' IN ('F','Y','I') THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; TRUE
2007-04-23, 4809👍, 0💬
Popular Posts:
How To Wirte a Simple JUnit Test Class? This is a common test in a job interview. You should be able...
What Is URI? URI (Uniform Resource Identifier) is a superset of URL. URI provides a simple and exten...
What CLASSPATH Settings Are Needed to Run JUnit? It doesn't matter if you run your JUnit tests from ...
Can include files be nested? The answer is yes. Include files can be nested any number of times. As ...
What does a special set of tags <?= and ?> do in a PHP script page? <?= express...