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?

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

Original text of this message