Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Number Conversion Problems...Scientific Notation!

Re: Number Conversion Problems...Scientific Notation!

From: Chris McCauley <Chris.McCauley_at_ilim.com>
Date: Fri, 29 May 1998 10:27:43 +0100
Message-ID: <356E7F8F.3A4C1899@ilim.com>


Hi Andrew and Mark,

We have the same problem with a fund managment system using oci to connect C++ clients to an Oracle 8 db on Windows NT. Is there anyway to obtain the precise value without resorting to using strings? Any help is appreciated.

Chris

Andrew Protasov wrote:

> Hi Mark,
>
> Try to_char(x) instead of to_char(x,20). This solution will not pad string
> with spaces at left or at right.
>
Received on Fri May 29 1998 - 04:27:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US