RE: Odd math

From: DEVERGE Philippe <Philippe.DEVERGE_at_opt.nc>
Date: Wed, 12 Jul 2000 15:59:09 +1100
Message-Id: <10555.111754@fatcity.com>

Hello Steve,

Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production With the Partitioning and Objects options PL/SQL Release 8.0.5.0.0 - Production

Entr=E9e limit=E9e =E0 15 caract=E8res
SQL> select trunc(log(2,4)) from dual;

TRUNC(LOG(2,4))

---

              1

Same result.

	Regards
	Philippe Deverge


> -----Message d'origine-----

> De:	Steve Adams [SMTP:steve.adams_at_ixora.com.au]

> Date:	mercredi 12 juillet 2000 16:15

> =C0:	Multiple recipients of list ORACLE-L

> Objet:	Odd math

>=20

> Hi All,

>=20

> Oracle 8.1.6 appears to think that ... trunc(log(2, 4)) =3D 1.

>=20


> 	SQL> select trunc(log(2,4)) from dual;

>=20


> 	TRUNC(LOG(2,4))

> 	---------------

> 	              1

>=20

> Does it reproduce on earlier versions?

>=20

> Regards,
> Steve Adams
> http://www.ixora.com.au/
> http://www.oreilly.com/catalog/orinternals/
> http://www.christianity.net.au/

>=20

> --=20
> Author: Steve Adams
> INET: steve.adams_at_ixora.com.au

>=20


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing =

Lists


> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Jul 11 2000 - 23:59:09 CDT