> NULL Summary Table:
Concept Rule
What is NULL Absence of any value
NULL = NULL FALSE - never equal
NULL = 0 FALSE - completely different
Check for NULL Use IS NULL / IS NOT NULL
Math with NULL Always results in NULL
Replace NULL Use NVL() function
NULL in ASC orderAppears LAST
NULL in DESC orderAppears FIRST
#OracleSQL#NullValues#NVL#IsNull#COALESCE#LearnSQL#SQLBeginners#Day9#100DaysOfCode#TechTwitter