Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Is there any predefined Oracle constants there denominate very large number ?

Re: Is there any predefined Oracle constants there denominate very large number ?

From: <Ranko.Mosic_at_gmail.com>
Date: 28 Nov 2005 13:13:16 -0800
Message-ID: <1133212396.869903.110830@o13g2000cwo.googlegroups.com> 





It is Oracle 9i.


Just got answer from very knowledgeable guy named Tom Kyte - there is
no constant like that.


There is BINARY_FLOAT_INFINITY and BINARY_DOUBLE_INFINITY in 10g.
Nothing in 9i and for number data type.  Instead use "number", rpad(
'9',38,'9'), he says.



Regards, Ranko
Received on Mon Nov 28 2005 - 15:13:16 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US