Oracle IN Operator with Example

In Oracle the IN operator used to compare a column with one or more than one value.

It always used with where clause.

Oracle IN Operator Syntax

To add a column in a table, the syntax is

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

Suppose we have to fetch all record from the user_table where city name is equal to Pune, Mumbai.In this case we have to use IN operator.

Sl No Name City Email ID
1 Virat Delhi
2 Sachin Mumbai
3 Dhoni Ranchi
4 Raina Pune
SELECT * FROM Customers WHERE City IN ('Pune', 'Mumbai');


Sl No Name City Email ID
2 Sachin Mumbai
4 Raina Pune

Connection failed: SQLSTATE[28000] [1045] Access denied for user 'studentdb'@'localhost' (using password: YES)