ORACLE IN

In Oracle, In clause is used with SELECT, INSERT, UPDATE, or DELETE statement to decrease the use of multiple OR conditions.

Syntax

expressions IN (value1, value2,.... value n)  

Parameters

Expressions: name of the column for getting value.

Table:

Example 1

Query: select *from table1 where name in (‘shristee’, ‘dolly’, ‘sid’)