Re: SqlPlus Question

In article <95d8d5$vgu$1_at_nnrp1.deja.com>,   kachkar_at_my-deja.com wrote:
> Hi all,
>
> I have a number column in my table let us say trunover ,when I run
> this sql using Sqlplus : select trunover from mytable;
> I get some values like this for example:
>
> 999.99
>
> and when my workmate does the same command from his machine using also
> sqlplus he gets this output
>
> 1000.00
>
> I know it is something in the client environment but I do not know how
> to fix this problem.
>
> Please, if you can help that would be great.
>
> Thanks in advance.
>

My best guess is that the setting for number width and/or number format are set differently. Try issuing show numwidth and show numformat from both sessions.

If that does not answer your question then issue the command, column, to see all column settings in effect.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com
http://www.deja.com/