NUMBER(1,-2): Variable with a scale of -2 can only hold values like 100,200,300... up to 900. : Number « PL SQL Data Types « Oracle PL/SQL Tutorial






SQL>
SQL> SET ECHO ON
SQL> SET SERVEROUTPUT ON
SQL>
SQL>
SQL> DECLARE
  2    hundreds_counter  NUMBER(1,-2);
  3  BEGIN
  4    hundreds_counter := 100;
  5    LOOP
  6      DBMS_OUTPUT.PUT_LINE(hundreds_counter);
  7      hundreds_counter := hundreds_counter + 100;
  8    END LOOP;
  9  EXCEPTION
 10  WHEN OTHERS THEN
 11    DBMS_OUTPUT.PUT_LINE('That is as high as we can go.');
 12  END;
 13  /
100
200
300
400
500
600
700
800
900
That is as high as we can go.

PL/SQL procedure successfully completed.

SQL>
SQL>








21.14.Number
21.14.1.NUMBER
21.14.2.NUMBER Subtypes
21.14.3.Identical declarations using NUMBER subtypes.
21.14.4.Number type variable
21.14.5.Assign value to NUMBER type variable
21.14.6.NATURAL value Computation
21.14.7.Assigning a Fraction to an Integer
21.14.8.Setting Precision and Scale
21.14.9.NUMBER(1,-2): Variable with a scale of -2 can only hold values like 100,200,300... up to 900.
21.14.10.NUMBER Data type: integer, fixed point and floating point
21.14.11.Select a number value from a table into a variable and output it
21.14.12.IF statement with number value check