oIN is used to check whether an attribute value matches a value contained within a (sub)set of listed values.
oExample:
;SELECT * FROM PRODUCT
WHERE V_CODE IN (21344,
24288);
oEXISTS is used to
check whether an attribute has value.
oExample:
;DELETE FROM PRODUCT
WHERE P_CODE EXISTS;
;
;SELECT * FROM PRODUCT
WHERE V_CODE EXISTS;