How To Use IN Conditions?
Page 1 of 1
How To Use IN Conditions?
by Micheal Sat Jan 16, 2010 9:23 pm
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
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
Micheal- Admin
- Posts : 243
Join date : 2010-01-10 -
Similar topics» How To Use LIKE Conditions?
» How To Use NULL as Conditions?
» How To Use Regular Expression in Pattern Match Conditions?
» How To Use NULL as Conditions?
» How To Use Regular Expression in Pattern Match Conditions?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
» Accessing tables of other users in SQL
» Grouping commands in SQL
» Operations on Result Sets in SQL
» Subqueries in SQL
» Joining Relations in SQL
» Delete comand in SQL
» Update command in SQL
» Insert command in SQL