ORACLE IN

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

Syntax

snippet
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
Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents