NOT IN Test Cases

View All Public Scripts Login to Run Script

Statement 1

select 'true' 
from dual 
where (1) not in (2,null)

no data found

Statement 2

select 'true' 
from dual 
where (1) not in (null, 2)

no data found

Statement 3

select 'true' 
from dual 
where (1,2) not in ((2,null))


'TRUE'
true

'TRUE'
true

Statement 4

select 'true' 
from dual 
where (1,2) not in ((null,2))

no data found

Additional Information