In Oracle the NOT IN operator used to compare a column with one or more than one value.
It always used with where clause.
To add a column in a table, the syntax is
Suppose we have to fetch all record from the user_table where city name is equal to Pune, Mumbai.In this case we have to use IN operator.
|Sl No||Name||City||Email ID|