Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is there any predefined Oracle constants there denominate very large number ?
Ranko.Mosic_at_gmail.com wrote:
> Question was very clear - Tom Kyte and some other people understood and
> immediatelly responded.
> Sign of bad IT person: when presented with question/challenge they ask
> " Why ? ( do you want to do it; would there be something like it )
> ..."; or answer is not reply to your question, but something you know
> about ( not necessarily related to the question )
> I was just asked if something like this exists, and it turns out 10g
> has some constants like that,
> like above mentioned BINARY_DOUBLE_INFINITY. So problem presented here
> is not that unusual.
> Fact that you don't know something, didn't think of something, or can't
> strech your brain a little doesn't have to provoke
> inelegant/mediocre/attacking responses.
> And constant can be assigned a value.
>
> Regards, Ranko.
Well I'm still intrigued about what the point of it might be. The
examples in the documentation are not much help.
"WHERE salary < BINARY_FLOAT_INFINITY"
would seem to be the same as
"WHERE salary IS NOT NULL".
Received on Fri Dec 02 2005 - 18:52:56 CST