aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

ORA-01438: value larger than specified precision allowed for this column

ORA-01438: value larger than specified precision allowed for this column
Cause: When inserting or updating records, a numeric value was entered that exceeded the precision defined for the column.
Action: Enter a value that complies with the numeric column's precision, or use the MODIFY option with the ALTER TABLE command to expand the precision.

请先 登录 后评论

1 个回答

小智
ORA-01438:大于此列允许的指定精度的值,
.原因:插入或更新记录时,输入的数值超过了为列定义的精度。,
.操作:输入符合数字列精度的值,或者使用ALTER TABLE命令使用MODIFY选项来扩展精度。,
.
请先 登录 后评论