RE: Odd math

From: Alvarez, Carlos <CAlvarez_at_uniFON.com.ar>
Date: Wed, 12 Jul 2000 10:57:00 -0300
Message-Id: <10556.111801@fatcity.com>

Yes, it happens in 7.3

SQL*Plus: Release 3.3.4.0.1 - Production on Wed Jul 12 10:59:37 2000

Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.

Conectado a:
Oracle7 Server Release 7.3.4.4.0 - Production With the distributed and replication options PL/SQL Release 2.3.4.4.0 - Production

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

TRUNC(LOG(2,4))

---

              1

Regards,=20

Carlos.
> ----------
> De: Steve Adams[SMTP:steve.adams_at_ixora.com.au]
> Responder a: ORACLE-L_at_fatcity.com
> Enviado el: Mi=E9rcoles 12 de Julio de 2000 02:15
> Para: Multiple recipients of list ORACLE-L
> Asunto: 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 Wed Jul 12 2000 - 08:57:00 CDT