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