RE: Odd math

From: Afanassiev, Alex <Alex.Afanassiev_at_team.telstra.com>
Date: Wed, 12 Jul 2000 15:00:02 +1000
Message-Id: <10555.111755@fatcity.com>

Hi Steve

Yes for 7.3.4 and 8.1.5.1

Oracle7 Server Release 7.3.4.3.0 - Production With the parallel query option
PL/SQL Release 2.3.4.3.0 - Production

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

TRUNC(LOG(2,4))

---

              1

SQL> uat7:edx0:/ora/admin> sqlplus /

SQL*Plus: Release 8.1.5.0.0 - Production on Wed Jul 12 14:59:04 2000

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.5.1.0 - Production With the Partitioning and Java options
PL/SQL Release 8.1.5.1.0 - Production

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

TRUNC(LOG(2,4))

---

              1

SQL> With regards
Alex Afanassiev
Oracle DBA, TOC OPS/Internet.Operations

Tel:	(03) 8 661 20 61
Fax:	(03) 9 650 36 74




> -----Original Message-----

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

> Sent:	Wednesday, July 12, 2000 3:15 PM

> To:	Multiple recipients of list ORACLE-L

> Subject:	Odd math

>
> Hi All,
>
> Oracle 8.1.6 appears to think that ... trunc(log(2, 4)) = 1.
>
> SQL> select trunc(log(2,4)) from dual;
>
> TRUNC(LOG(2,4))
> ---------------
> 1
>
> Does it reproduce on earlier versions?
>
> Regards,
> Steve Adams
> http://www.ixora.com.au/
> http://www.oreilly.com/catalog/orinternals/
> http://www.christianity.net.au/
>
> --
> Author: Steve Adams
> INET: steve.adams_at_ixora.com.au
>
> 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
Received on Wed Jul 12 2000 - 00:00:02 CDT