greatest « Numeric Math Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Numeric Math Functions
  3. greatest
1.GREATEST() returns the greatest of the list of expressions.
2.select greatest( 'A', 'a' )from dual;
3.select greatest( 'ONE', 1 )
4.select greatest( 1, 5, 10 )
5.GREATEST(12*6,148/2,73) LEAST(12*6,148/2,73)
6.This script demonstrates the Greatest functions