Oracle PL/SQL Tutorial/Miscellaneous Functions/GREATEST

greatest(12*6,148/2,73)

   <source lang="sql">

SQL> SQL> SQL> select greatest(12*6,148/2,73)

 2  from   dual;

GREATEST(12*6,148/2,73)

---

                    74

SQL></source>

GREATEST(12*6,148/2,73) LEAST(12*6,148/2,73)

   <source lang="sql">

SQL> SQL> select greatest(12*6,148/2,73)

 2  ,      least   (12*6,148/2,73)
 3  from   dual;

GREATEST(12*6,148/2,73) LEAST(12*6,148/2,73)

---

--------------------

                    74                   72

SQL> SQL></source>

This script demonstrates the Greatest functions

   <source lang="sql">

SQL> SQL> SET SERVEROUTPUT ON SQL> DECLARE

 2     v_char VARCHAR2(10);
 3     v_number NUMBER(10);
 4  BEGIN
 5
 6     v_char := GREATEST("A", "B", "C");
 7     v_number := GREATEST(1,2,3);
 8
 9     DBMS_OUTPUT.PUT_LINE("Greatest Character: "||v_char);
10     DBMS_OUTPUT.PUT_LINE("Greatest Number: "||v_number);
11
12  END;
13  /

Greatest Character: C Greatest Number: 3 PL/SQL procedure successfully completed. SQL> SQL></source>

Use the Greatest functions

   <source lang="sql">

SQL> SQL> SQL> SET SERVEROUTPUT ON SQL> DECLARE

 2     v_char VARCHAR2(10);
 3     v_number NUMBER(10);
 4  BEGIN
 5
 6     v_char := GREATEST("A", "B", "C");
 7     v_number := GREATEST(1,2,3);
 8
 9     DBMS_OUTPUT.PUT_LINE("Greatest Character: "||v_char);
10     DBMS_OUTPUT.PUT_LINE("Greatest Number: "||v_number);
11
12
13  END;
14  /

Greatest Character: C Greatest Number: 3 PL/SQL procedure successfully completed. SQL> SQL></source>