Inserting "Infinity"

From: CaseMan <droth_at_adaptron.com>
Date: 2000/02/23
Message-ID: <38b3da3d.34942454_at_news.tiac.net>#1/1


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 Wed Feb 23 2000 - 00:00:00 CET

Original text of this message