“NOT IN” clause is not the opposite of “IN” clause. Because NULL rows can cause confusion.
In order to solve the problem convert NULL values to 0 by using:
select * from mytable where NVL(userid,'0') not in ('4','7','15')
“NOT IN” clause is not the opposite of “IN” clause. Because NULL rows can cause confusion.
In order to solve the problem convert NULL values to 0 by using:
select * from mytable where NVL(userid,'0') not in ('4','7','15')
select * from v$session
select * from v$process
SELECT * FROM SYS.ALL_CONSTRAINTS