The Oracle IN operator helps you to reduce the use of multiple OR conditions in a SELECT, INSERT, UPDATE, or DELETE statement.
To reduce the use of multiple OR conditions, use the following syntax:
Parameters:
expression : The specified value to test.
value1, value2: Values to test against expression.
IN
operator is used reduce the use of multiple OR conditions. If any of these values matches expression, then the IN
operator will evaluate to true:
Note:
In the above example, we are performing IN
operator to test the multiple values against expression.