René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

greatest and least [Oracle SQL]

greatest (expr-1)
greatest (expr-1, expr_2)
greatest (expr-1, expr_2, ..., expr-n)

least (expr-1)
least (expr-1, expr_2)
least (expr-1, expr_2, ..., expr-n)
select least(44, 22, 49, 8, 102) from dual;
8
select greatest(44, 22, 49, 8, 102) from dual;
102