Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Simple problem...
Morning T,
>> 3: Norman's - similar with added stuff on to_float - seems like
Round() is
>> faster when checking for a float.
>> 4: Daniel's modulus solution for is_an_int.
I did a bit of testing this morning and found the MOD is slower for float and integer values - ROUND is the winner.
Cheers,
Norman.
Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.com -------------------------------------Received on Fri Feb 28 2003 - 04:31:54 CST