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?

column <column_name> format <any format model available in to_char> 999.999999
as defined in the sqlplus reference manual.

Hth

Sybrand Bakker, Oracle DBA Received on Sat Aug 25 2001 - 10:02:52 CEST