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 below:
SELECT 3 IN (1,2,3,4,5) FROM DUAL;
1
SELECT 3 NOT IN (1,2,3,4,5) FROM DUAL;
0
SELECT Y’ IN (‘F’,’Y’,I) FROM DUAL;
1
Otherwise, it returns FALSE.
Some examples are given below:
SELECT 3 IN (1,2,3,4,5) FROM DUAL;
1
SELECT 3 NOT IN (1,2,3,4,5) FROM DUAL;
0
SELECT Y’ IN (‘F’,’Y’,I) FROM DUAL;
1
No comments:
Post a Comment