Re: base number conversion
From: Vivekanandhan Raja <vraja_at_us.oracle.com>
Date: 1996/01/02
Message-ID: <4cc3r7$ilf_at_inet-nntp-gw-1.us.oracle.com>#1/1
Date: 1996/01/02
Message-ID: <4cc3r7$ilf_at_inet-nntp-gw-1.us.oracle.com>#1/1
ORACLE does provide transcendental functions like log() and power(). To convert a number P = XbaseY to number P = AbaseB do the following :
A = X log Y base B.
X = A log B base Y.
select X * log(Y,B) from dual ; /* base Y to base B */ select A * log(B,Y) from dual ; /* base B to base Y */
Beware of floating point roundoffs that may occur .... Received on Tue Jan 02 1996 - 00:00:00 CET