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>