This script demonstrates the Greatest functions : GREATEST « Miscellaneous Functions « Oracle PL/SQL Tutorial






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>








17.2.GREATEST
17.2.1.Use the Greatest functions
17.2.2.greatest(12*6,148/2,73)
17.2.3.This script demonstrates the Greatest functions
17.2.4.GREATEST(12*6,148/2,73) LEAST(12*6,148/2,73)