In Oracle, In clause is used with SELECT, INSERT, UPDATE, or DELETE statement to decrease the use of multiple OR conditions.
expressions IN (value1, value2,.... value n)
Expressions: name of the column for getting value.
Query: select *from table1 where name in ('shristee', 'dolly', 'sid')
