InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How To Use In Conditions? |
|
Answer» 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 : 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; 1An 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 : |
|