SQLPLUS - visualisation of number field type

From: Martin Doering <doeringm_at_gmx.de>
Date: Fri, 24 Aug 2001 11:33:18 GMT
Message-ID: <3b8639db.22059509_at_news.mn.man.de>

[Quoted] [Quoted] 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?

--
Martin Doering

Received on Fri Aug 24 2001 - 13:33:18 CEST