This script demonstrates the Least functions : least « Numeric Math Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Numeric Math Functions
  3. least

This script demonstrates the Least functions

  

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

PL/SQL procedure successfully completed.

SQL>
SQL>








Related examples in the same category

1.select least( 'X', 'x' ) from dual;
2.select least( 'A', 'B', 'C' ) from dual;
3.Use least() to limit the value