Home » SQL & PL/SQL » SQL & PL/SQL » NAN and INFINITE
NAN and INFINITE [message #193508] Mon, 18 September 2006 00:16 Go to next message
selvakumar_82
Messages: 138
Registered: October 2005
Location: chennai
Senior Member
Hi Frieds,

when i started reading about Oracle 10g Features ..I come across NAN and INFINITE..

What is the use of NAN and INFINITE in oracle ....?

Thanx and Regards
Selva.R
Re: NAN and INFINITE [message #193540 is a reply to message #193508] Mon, 18 September 2006 02:56 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
They are used with floating point numbers to determine if an expression matches the +/-INF condition or the NaN (not a number) condition.

DOcumentation
Previous Topic: Calling Java services from PL/SQL
Next Topic: Zero rows in User_Tables
Goto Forum:
  


Current Time: Wed Dec 07 12:22:48 CST 2016

Total time taken to generate the page: 0.08262 seconds