Oracle decimals Reserved

Oracle retains decimal places. When we are working on a project today, we will find the data in one table and update it to another table. However, an error is reported during execution. The error is as follows: www.2cto.com SQL code ORA-01438: The value is greater than the allowed precision specified for this column to view, found that the data decimal point is long, such as 24632.458674. And then use an Oracle function to solve the problem. Example: SQL code select round (12345.66666, 2) from dual returns 12345.67. That is, two decimal places are retained and rounded.