IN OPERATOR

The IN operator returns records matching one of the values listed in the condition. Oracle 11g syntax requires separating list items with commas, and the entire list must be enclosed in parentheses.

SELECT title, pubid
FROM books
WHERE pubid IN (1,2,5);

SELECT firstname, lastname, state
FROM customers
WHERE state IN('CA','TX');

SELECT firstname, lastname, state
FROM customers
WHERE state NOT IN('CA','TX');

Back To Top- Home - Category