This will give the least string.
Syntax: greatest (strng1, string2,
string3 … stringn)
Ex:
SQL> select least('a', 'b', 'c'), least('satish','srinu','saketh') from
dual;
LEAST LEAST
------- -------
a saketh
Ø If all the
parameters are nulls then it will display nothing.
Ø If any of the
parameters is null it will display nothing.