numeric field truncation.

[david604]

I have a field on a table that is a number datatype. When I select on this column in PL/SQL Developer I am getting only 7 characters returned, but the length is actually 9 characters. I can confirm this just fine in SQL*Plus. With PLSQL developer though the field is getting truncated when returning.

Is there a setting that controls this? What causes this please?
Thanks
- Dsavid

 

[Marco Kalter]

Are you using the Command Window or the SQL Window? If you are using the Command Window, can you type SET NUMWIDTH to verify the maximum number width setting?