Why do i get #### in the NUMBER column after format... Oracle?

oracle numbers format sqlplus
CHEBURASHKA picture CHEBURASHKA · Jun 24, 2013 · Viewed 47.7k times · Source

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

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

i get

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

Answer

Justin Cave picture Justin Cave · Jun 24, 2013

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

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).

Related questions

oracle varchar to number

How do i convert a oracle varchar value to number eg table - exception exception_value 555 where exception_value is a varchar type I would like to test the value of exception_value column select * from exception where exception_value = 105 …

Read More
Oracle NUMBER(p) storage size?

I've searched for it but i can't find a conclusive answer to my question... I need to know what is the storage size of a number(p) field in Oracle. Examples: NUMBER(1), NUMBER(3), NUMBER(8), NUMBER(10) etc...

Read More
How to display the leading zero's in a number of oracle

I have an oracle column(artnr) contains a length of 1 which is of type number(9). I want to update the number as following... Example : If number is 0 then it should be 00000 If number is 1 then it should be 00001 If number …

Read More