Topics

• Table partitioning
• Handling NULL values

Examples

• Columns of any data type can contain NULLs
• Empty strings are NULL
• Operations containing NULL are NULL, except concatenation
• NVL to replace null value
• NVL2 to get a different result if a value is null or not
• COALESCE to return the first non-NULL value