This section provides you with the SQL comparison functions including COALESCE, DECODE, and NULLIF.
Name | Description |
COALESCE | Return the first non-null argument in the argument list. |
DECODE | Learn how to add the procedural if-then-else logic to SQL queries. |
NULLIF | Compare two expressions and return null if they are equal, otherwise, return the first expression. |