SQL & PL/SQL

Version :11.2

What is the point in having PRECISION and SCALE in number type? If you create the column with just NUMBER ie.without
specifying precision or scale , you can enter numbers with any precision and scale.

SQL> select * From v$version where rownum < 2;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production


SQL> create table t1 (col1 number);

Table created.

SQL> insert into t1 values (223.9939394);

1 row created.

SQL> insert into t1 values (88.228384);

1 row created.

SQL> insert into t1 values (9.34);

1 row created.

SQL> insert into t1 values (000.00);

1 row created.

SQL> commit;

Commit complete.

SQL> select * from t1;

      COL1
----------
223.993939
 88.228384
      9.34
         0

Did you ever have a business scenario where a Numerical column should store values only with a fixed precision and scale ?