Consider the following table definition:
CREATE TABLE num_tab (n1 NUMBER(*,3), n2 NUMBER, n3 NUMBER(*), n4 NUMBER(5,1), n5 NUMBER(3) );
The following table shows the result of inserting values into a column defined as NUMBER (3).
| Inserted Value | Value of Column n5 |
|---|---|
| 1.234 | 1 |
| 123.6789 | 124 |
| 1234.56 | An error is returned because the inserted value exceeds the size of column n5. |
The following table shows the result of inserting values into a column defined as NUMBER (*,3).
| Inserted Value | Value of Column n1 |
|---|---|
| 1.234 | 1.234 |
| 1234.6789 | 1234.679 |