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:
expression : The specified value to test.
value1, value2: Values to test against expression.
INoperator is used reduce the use of multiple OR conditions. If any of these values matches expression, then the
INoperator will evaluate to true:
In the above example, we are performing
IN operator to test the multiple values against expression.