Comments for NULL-Related Functions
Connor said...SYS_OP_MAP_NONNULL is also very useful, aka
where sys_op_map_nonnull(nullable_col) != sys_op_map_nonnull(other_nullable_col)
I've added it.
Gabriel said...Good Article! Thanks
Gayathri chandraseka said...Tim
Very useful article.
TBlackbird said..."It is possible to make this happen using the NVL and DECODE functions, but this relies on you converting the null value..."
"In a DECODE function, Oracle considers two nulls to be equivalent."
DECODE(A, B, 1, 0) = 1
is equivalent to
A = B OR (A IS NULL AND B IS NULL)
Correct. I've even given an example of it earlier. :) I've altered the wording slightly and put in another example to show that variation of the usage.
DO NOT ask technical questions here! They will be deleted!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!