From: Mark D Powell <markp7832@my-deja.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: SqlPlus Question
Date: Fri, 02 Feb 2001 14:45:10 GMT
Organization: Deja.com
Lines: 36
Message-ID: <95eh5k$vk1$1@nnrp1.deja.com>
References: <95d8d5$vgu$1@nnrp1.deja.com>
NNTP-Posting-Host: 199.228.142.8
X-Article-Creation-Date: Fri Feb 02 14:45:10 2001 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)
X-Http-Proxy: 1.0 x60.deja.com:80 (Squid/1.1.22) for client 199.228.142.8
X-MyDeja-Info: XMYDJUIDmarkp7832


In article <95d8d5$vgu$1@nnrp1.deja.com>,
  kachkar@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/