Orcale SQL Tutorial

In

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:

ORACLE IN

Example 1

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

ORACLE IN