Use the Least functions : LEAST « Miscellaneous Functions « Oracle PL/SQL Tutorial






SQL>
SQL>
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
  2     v_char VARCHAR2(10);
  3     v_number NUMBER(10);
  4  BEGIN
  5
  6     v_char := LEAST('A', 'B', 'C');
  7     v_number := LEAST(1,2,3);
  8
  9     DBMS_OUTPUT.PUT_LINE('Least Character: '||v_char);
 10     DBMS_OUTPUT.PUT_LINE('Least Number: '||v_number);
 11
 12
 13  END;
 14  /
Least Character: A
Least Number: 1

PL/SQL procedure successfully completed.








17.3.LEAST
17.3.1.Use the Least functions
17.3.2.select least(12*6,148/2,73)
17.3.3.This script demonstrates the Least functions
17.3.4.Use least() to limit the value