Oracle Database Tutorial 8: The 'IN' Operator In Sql

he SQL IN Operator
The IN operator allows you to specify multiple values in a WHERE clause.

The IN operator is a shorthand for multiple OR conditions.

IN Syntax
SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);
or:

SELECT column_name(s)
FROM table_name
WHERE column_name IN (SELECT STATEMENT);
not in operator in sql

sql where multiple values

@ symbol in sql

sql where in list

sql where multiple conditions

sql between

sql like