Ora-01438:value larger than specified precision for this column

Ora-01438:value larger than specified precision for this column

When the eye is clear, the field length is not enough.

INSERT INTO OSS_ADDR_MON_STATS_TMP06
Select/*+use_hash (a,c) * *
Provcode,
AreaCode,
Count (A.serialid) as Self_group_serial_num--count the number of contacts in the custom group tmp06
From OSS_ADDR_MON_STATS_TMP05 A
INNER JOIN oss_addr_mon_stats_tmp04 C on A.usernumber=c.usernumber and A.groupid=c.groupid
Group BY Provcode,areacode;

Run this statement from the production library, the result is no data too long ah,

and copy the results to the corresponding table in the development library, and the insertion is normal.

--Create table
CREATE TABLE Oss_addr_mon_stats_tmp06
(
Self_group_serial_num number (a) default 0,
Provcode Number (5) is not NULL,
AreaCode Number (5) NOT NULL
)

Look at the following table structure Insertion order reversed.