What's different btw 'NOT EXIST' and 'NOT IN'?

[6656]

Greetings,

What's different between 'NOT EXIST' and 'NOT IN' in Where clause?

Thanks.
Mike

 

[taupirho]

One difference is the way that nulls are handled (or not) by NOT IN

See the following for a good discussion

http://asktom.oracle.com/pls/asktom/fp=100:11:1848861021317856::::P11_QUESTION_ID:442029737684

In order to understand recursion, you must first understand recursion.

 

[6656]

Thanks taupirho,

Unfortunately, the link is not available.

 

[Ascalonian]

Try this link instead:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:442029737684

 

[6656]

Thanks all. It is a very good reference.