Excel Function : IMLOG2
Returns the base-2 logarithm of a complex number
Microsoft Excel Reference Page
Syntax and Description of the IMLOG2 Excel Function
I am trying to use IMLOG2 excel function in oracle to calculate the log base 2 of the field.
I have tried using the below syntax but the function is not recognized by oracle.
select IMLOG2(fieldname1) from tablename1
Could someone please help me with the syntax.
Thanks in Advance
The IMLOG2 function isn't built into Oracle. You'll either have to write your own (which is probably easy enough) or find it somewhere else.
About IMLOG2 Excel Function
IMLOG2(number) The IMLOG2 function returns the logarithm base 2 of a positive number.