PLS-00510: Float cannot have scale

PLS-00510: Float cannot have scale
Cause: When a FLOAT variable was declared, its precision and scale were specified, as shown in the following example: DECLARE Salary FLOAT(7,2); However, a scale for FLOAT variables cannot be specified; only a precision can be specified, as in salary FLOAT(7);
Action: Remove the scale specifier from the declaration, or declare a NUMBER variable instead.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00510：浮子不能有刻度,
.原因：当声明了一个FLOAT变量时，它的精度和比例被指定，如下例所示：DECLARE Salary FLOAT（7,2）; 但是，无法指定FLOAT变量的缩放比例; 只有精度可以指定，如在工资FLOAT（7）中;,
.操作：从声明中删除比例说明符，或者声明NUMBER变量。,
.

aiaiDBA

13718043309

010-86462881

PLS-00510: Float cannot have scale

1 个回答

相似问题