Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Odd math

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US