数字数据类型在SQL Plus中显示为# [英] Number data type showing up as # in SQL Plus
问题描述
数字数据类型显示为#而不是SQL Plus中的数字.
请先参考H_RATE,以解决问题的正确显示,并且我已经在互联网和stackoverflow上搜索了类似的问题或答案,但都没有相同的问题.
您能帮忙解决它,以便显示数字而不是#吗?
如果该值不适合该列,则显示
#
;否则,将显示
如果该列中不能容纳一个值,则SQL * Plus将显示井号(#)而不是数字.
如果它显示的是OK,但现在却不行,我认为您可能设置的列格式对于所显示的值来说太小了,例如column h_rate format 9999999999
.如果您输入的10位数字还不够用,因为它需要一个字符来显示+/-符号.
您可以通过清除所有列定义来检查是否是这种情况,方法是 解决方案
#
is displayed if the value can't fit in the column; from the SQL*Plus documentation:
If a value cannot fit in the column, SQL*Plus displays pound signs (#) instead of the number.
If it was displaying OK and now isn't, I think you've probably set a column format that is too small for the values you're display, something like column h_rate format 9999999999
. If you have a 10-digit number that isn't enough, as it needs a character to display a +/- sign.
You can check if that is the case by clearing all column definitions, with clear columns
.
这篇关于数字数据类型在SQL Plus中显示为#的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!