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

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORACLE DOESN'T COMPLY TO BASIC STANDARD SQL: SIMPLE QUERIES DOESN'T WORK

Re: ORACLE DOESN'T COMPLY TO BASIC STANDARD SQL: SIMPLE QUERIES DOESN'T WORK

From: <joel-garry_at_home.com>
Date: 4 Nov 2005 17:30:44 -0800
Message-ID: <1131154244.869599.177490@g49g2000cwa.googlegroups.com>


Appears to be NOK on hp-ux 11 9206.

   1/VALUE


     -.125

.1
NMBR ---------- -.125
.1
(select 1/value from IntNumbers Where Kind='POSITIVE INT' or *

ERROR at line 2:
ORA-01476: divisor is equal to zero

      NMBR


.5

SQL> It appears to be taking the number from the set of NOT ('POSITIVE INT' ,'NEGATIVE INT') and dividing that, which happens to be 0, into 1, which would not be correct.

Works fine on XE.

jg

-- 
@home.com is bogus.
Received on Fri Nov 04 2005 - 19:30:44 CST

Original text of this message

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