Oracle NOT IN Operator with Example

In Oracle the NOT IN operator used to compare a column with one or more than one value.

It is often used in conjunction with the SELECT statement to retrieve data from a table that doesn't match any of the values in a given list.

It always used with where clause.

Here's the basic syntax of the NOT IN operator:

• column1, column2, ...: The columns you want to retrieve in the result set.
• table_name: The name of the table you're querying.
• column_name: The column you want to compare against the list of values.
• value1, value2, ...: The list of values to check for in the specified column.

Suppose we have to fetch all record from the user_table where city name is not equal to Pune, Mumbai.In this case we have to use NOT IN operator.

Output