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

On Thu, 03 Nov 2005 03:17:38 -0800, LP wrote:

> select nmbr from Numbers where nmbr not in
> (select 1/value from IntNumbers Where Kind='POSITIVE INT' or
> Kind='NEGATIVE INT') ;
> REM return Error 1476 divisor is equal to zero and return no lines
> REM should return one line and no error ???
> REM so Oracle doesn't comply to basic sql standard
>

I don't understand. Are you saying that this returns 1476? I just tried it with a supported version of the database (10gR2) and got the following:

SQL> l
  1 select nmbr from Numbers where nmbr not in   2 (select 1/value from IntNumbers Where Kind='POSITIVE INT' or   3* Kind='NEGATIVE INT')
SQL> /       NMBR

        .5

SQL> (Perhaps you should move up to a supported version if you still find a problem. There are reasons why the old versions are unsupported.)

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting guarantees I will not respond further ***