The Oracle and PL/SQL LEAST function returns the smallest value in a list of expressions.
LEAST(expr1, expr2,...)
Oracle uses the first expr to determine the return type.
Example 1:
SELECT LEAST(1,3,6,89,56,3) FROM DUAL;
returns:
1
Example 2:
SELECT LEAST('red','yellow','blue') FROM DUAL;
returns:
blue