Comparison functions

The following table describes the supported comparison functions.

Function	Description
GREATEST	Returns the greatest value from a list of one or more expressions. The return type is based on the first expression: if numeric, Oracle uses the highest numeric precedence; if not numeric, other arguments are converted to the first expression’s data type.
LEAST	Returns the least value from a list of one or more expressions. The return type is based on the first expression: if numeric, Oracle uses the highest numeric precedence; if not numeric, other arguments are converted to the first expression’s data type.