Numeric Math Functions Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Numeric Math Functions
  4. GREATEST() returns the greatest of the list of expressions
SQL>
Syntax: GREATEST(,. . . )
SQL>
SQL> SELECT
  2     GREATEST('ALEX','WALTER','PHILLIP')   names,
  3     GREATEST(10,20,135)     numbers
  4  FROM dual;
NAMES     NUMBERS
------ ----------
WALTER        135
SQL>
SQL>
SQL>