General Functions

FunctionDescription
GREATEST(a, b, ...)Greatest value of the function arguments
LEAST(a, b, ...)Least value of the function arguments
NULLIF(a, b)NULL if a = b; otherwise a
COALESCE(a, b, ...)The first not NULL argument (and NULL if all arguments are NULL)
Home »
Oracle » 
General_Functions