Numeric data type displayed as # in SQL Plus

Question

The data type of a number displayed as # instead of numbers in SQL Plus.

Please refer to H_RATE because the problem was detected correctly, and I searched the Internet and stackoverflow for a similar problem or answer, but none of them have.

Could you help me fix it so that it displays a number instead of #?

Answer 1

# displayed if the value cannot be placed in the column; from the SQL * Plus documentation :

If a value cannot be placed in a column, SQL * Plus displays pound (#) icons instead of a number.

If it displays OK, but not now, I think you probably set the column format to too small for the displayed values, something like column h_rate format 9999999999 . If you have a 10-digit number, which is not enough, because he needs a character to display the +/- sign.

You can verify this by clearing all column definitions, clear columns .

Answer 2

The H_RATE format may have smaller data digits:

 select to_char(123,'99') from dual; --returns ### 

but make the formatting of something bigger than the data correct:

 select to_char(12345,'99,999') from dual; -- returns 12,345 

There are various formatting with oracle given here