Re: SQLPLUS - visualisation of number field type

On Fri, 24 Aug 2001 11:33:18 GMT, doeringm_at_gmx.de (Martin Doering) wrote:

>I have a question about the visualisation of the number field type:
>
>We have a field of type number (11,6). if I watch this with SQLPLUS I
>get e.g.:
>
>1428.57143
>
>It get's rounded. But the real number is:
>
>1428.571428
>
>I can see this, if I subtract 1428 from my number in my query - then
>the part after the comma is ok again. So in the data it must be right.
>
>I need this to unload data, and it needs to be right. Can I tell
>SQLPLUS, what precision to use?
>
>What can I do?

I found the answer myself:

There is an SQL*PLUS command:

column XXX format 99999.999999

This will do is Received on Fri Aug 24 2001 - 15:04:16 CEST