The following table lists the functions supported with their descriptions:
|
Function name |
Description |
|
COALESCE(expr1, expr2,...) |
Returns the first non-null argument. If all are null values, null is returned. |
|
GREATEST(expr1, expr2,...) |
Returns the largest argument. If all are null, null is returned. |
|
IFNULL(expr1, expr2) |
Returns expr2 if expr1 is null. Otherwise, expr1 is returned. |
|
ISNULL(expr1, expr2) |
Returns expr2 if expr1 is null. Otherwise, expr1 is returned. |
|
LEAST(expr1, expr2, ...) |
Returns the smallest argument. If all are null, null is returned. |
|
NULLIF(expr1, expr2) |
Returns null if expr1=expr2. Otherwise, expr1 is returned. |
|
NVL(expr1, expr2) |
Returns expr2 if expr1 is null. Otherwise, expr1 is returned. |