Define POSITIVE type variable : POSITIVE « PL SQL Data Types « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Data Types
  3. POSITIVE
SQL>
SQL> SET ECHO ON
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
  2    age   POSITIVE;
  3
  4  BEGIN
  5    age := 10;
  6    DBMS_OUTPUT.PUT_LINE('age:');
  7    DBMS_OUTPUT.PUT_LINE(age);
  8  END;
  9  /
age:
10

PL/SQL procedure successfully completed.








21.20.POSITIVE
21.20.1.Define POSITIVE type variable
21.20.2.An attempt to assign a negative value to a POSITIVE variable