The Oracle SELECT IN operator is used to reduce the use of multiple OR conditions in a SELECT, INSERT, UPDATE, or DELETE statement.
To reduce the use of multiple OR conditions in a SELECT, INSERT, UPDATE, or DELETE statement, use the following syntax:
Parameters:
tablename: The table name from which you want to fetch data.
conditions: The conditions optional parameter.
Note:
In the above example, we are reducing the use of multiple OR conditions.
Note:
In the above example, will return all rows where the "firstName is not 'Dev', 'Ramesh', 'Mahesh'.