Inserting "Infinity"
From: CaseMan <droth_at_adaptron.com>
Date: Mon, 21 Feb 2000 23:23:24 GMT
Message-ID: <38b1c591.178439802_at_news.tiac.net>
How can I insert the value "infinity" into a field using SQL?
Date: Mon, 21 Feb 2000 23:23:24 GMT
Message-ID: <38b1c591.178439802_at_news.tiac.net>
How can I insert the value "infinity" into a field using SQL?
Oracle documentation for numbers notes that the internal representation can store and distinguish infinity and minus infinity.
The infinity value can be inserted using Java.
When I dump an infinit value I get Typ=2 Len=2: 255,101
When I select an infinite value I get ~.
Any help would be appreciated.
Dave Received on Tue Feb 22 2000 - 00:23:24 CET