为什么我在格式化后的NUMBER列中得到####? [英] Why do I get #### in the NUMBER column after format?

问题描述

我有两列有问题的列: Fee NUMBER类型， AdjFee 也是NUMBER.

I have two problematic columns: Fee NUMBER type, AdjFee also NUMBER.

之后

column Fee format a5;
select Fee ID smth
from Visit;

我知道

Fee    ID   smth
####  123  klkl
####  654  rfjgr

推荐答案

您可以调整SQL * Plus用于显示数字数据的位数，就像调整用于显示字符数据的字符数一样.像

You can adjust the number of digits you want SQL*Plus to use to display the numeric data just as you adjust the number of characters used to display character data. Something like

column fee format 999999999.99

会告诉SQL * Plus在小数点前最多显示9位数字，在小数点后最多显示两位数字.当然，如果您知道自己的费用会小一些(或大一些)，则可以进行调整.

will tell SQL*Plus to display up to 9 digits before the decimal point and two after the decimal point. You can adjust that, of course, if you know your fees are going to be smaller (or larger).

这篇关于为什么我在格式化后的NUMBER列中得到####?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！