NUMBER Data type: integer, fixed point and floating point : Number « PL SQL Data Types « Oracle PL/SQL Tutorial






SQL>
SQL> declare
  2      v1_nr NUMBER(10);   -- integer
  3      v2_nr NUMBER(10,0); -- also integer
  4      v3_nr NUMBER(5,5);  -- fixed point
  5      v4_nr NUMBER(5,-3); -- also fixed point
  6      v5_nr NUMBER;       -- floating point
  7
  8  begin
  9     NULL;
 10
 11  end;
 12  /

PL/SQL procedure successfully completed.

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