LEAST

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