Identical declarations using NUMBER subtypes
SQL> SQL> SQL> -- Identical declarations using NUMBER subtypes. SQL> SET SERVEROUTPUT ON SQL> SQL> DECLARE 2 -- all these declarations are identical. 3 num_dec DECIMAL(5,2); 4 num_int INTEGER(5,2); 5 num_dbl DOUBLE PRECISION(5); 6 num_num NUMERIC(5,2); 7 num_real REAL(5); 8 num_sint SMALLINT(5,2); 9 num_flt FLOAT(17); 10 11 BEGIN 12 13 num_dec := 123.456; 14 num_int := 123.456; 15 num_dbl := 123.456; 16 num_num := 123.456; 17 num_real := 123.456; 18 num_sint := 123.456; 19 num_flt := 123.456; 20 21 DBMS_OUTPUT.PUT_LINE(num_dec); 22 DBMS_OUTPUT.PUT_LINE(num_int); 23 DBMS_OUTPUT.PUT_LINE(num_dbl); 24 DBMS_OUTPUT.PUT_LINE(num_num); 25 DBMS_OUTPUT.PUT_LINE(num_real); 26 DBMS_OUTPUT.PUT_LINE(num_sint); 27 DBMS_OUTPUT.PUT_LINE(num_flt); 28 END; 29 / 123.46 123.46 120 123.46 120 123.46 123.456 PL/SQL procedure successfully completed. SQL> SQL> SQL>