78

ORACLE IN

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

Syntax

Parameters

Expressions: name of the column for getting value.

Table:

Example 1

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