Community

filter IS NOT NULL

(Alexander Anokhin) Although Oracle is smart enough it is always helpful to double check. Even in cases where you expect that Oracle aware about nulls and it will apply necessary filters itself, result can be unexpected.

Read More - Register for Free Membership

Tags: