Oracle PL/SQL Least Function

The Least function returns returns the smallest value in a list of expressions.

The Least Function syntax:

least( exp1, exp2, … exp_n )

Example:

Select least(4, 7, 11, 9) From dual;
4

Select least('4', '7', '11', '9') From dual;
11

Select least('oracle', 'ibm', 'hp', 'dell') From dual;
dell

Select least('test1', 'test2', 'test3') From dual;
test1