ra-01438 value larger than specified precision allowed for this column

简介:

一般出现在数据库表的主键部分,比如id 你设置的是number(6) ,但是,现在数据库的主键ID值已经超过了6位。所以不能再继续插入数据了。而且会报这个错误!

 

解决:number(6) → number(>6)



     本文转自韩立伟 51CTO博客,原文链接:http://blog.51cto.com/hanchaohan/1185835,如需转载请自行联系原作者



相关文章
|
JSON fastjson 数据格式
报错:JSONException: illegal identifier : {pos 1, line 1, column 2{{"group":"trade_p0&qu
报错:JSONException: illegal identifier : {pos 1, line 1, column 2{{"group":"trade_p0&qu
538 0
成功解决lightgbm.basic.LightGBMError: Parameter max_depth should be of type int, got “0.02“
成功解决lightgbm.basic.LightGBMError: Parameter max_depth should be of type int, got “0.02“
Leetcode-Medium 416. Partition Equal Subset Sum
Leetcode-Medium 416. Partition Equal Subset Sum
116 0
How to give query view parameter values in APF
How to give query view parameter values in APF
116 0
How to give query view parameter values in APF
|
数据库
Data truncation: Out of range value for column ‘estimate_score‘
Data truncation: Out of range value for column ‘estimate_score‘
成功解决DataConversionWarning: A column-vector y was passed when a 1d array was expected. Please change
成功解决DataConversionWarning: A column-vector y was passed when a 1d array was expected. Please change
|
SQL
ORA-01440: column to be modified must be empty to decrease precision or scale
在修改表字段的NUMBER类型的精度或刻度时,你可能会遇到ORA-01440: column to be modified must be empty to decrease precision or scale,下面介绍一下,如何处理这个问题。
1591 0
|
文件存储
1019. General Palindromic Number (20)
A number that will be the same when it is written forwards or backwards is known as a Palindromic Number.
903 0