If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hi All,
I was able to fix the problem from help with Oracle support. This is what they said.

"the number itself is not being truncated, but the default column width for Number is set to 10. From SQL*Plus, use the command SET NUM nn where nn is the desired column width. Once doing so, you should be able to see all the numbers in that field"

My question to them now is
"why does the number width gets set to 10. Shouldnt it be based on
the table description. If it is set to Number(20) then it should be 20. I dont
want to set the number width for a sql session every time and also I dont want
to set it in the login.sql file and set it for all the sessions.
Shouldnt it be dynamic.
Also how do I find out the current settings of the number width"

Now I am waiting for their response and will post it when they get back to me.

Thanks
Anurag

Appreciation is a wonderful thing;
It makes what is excellent in others belong to us as well.