Re: Simple Query

From: L. Scott Johnson <sjohnson_at_math.scarolina.edu>
Date: 6 Feb 1995 13:54:01 GMT
Message-ID: <3h59lp$3g0_at_redwood.cs.scarolina.edu>


bhala_at_cs.utexas.edu (Bhalchandra Ghatate) writes:

>Now is this a bug: ?
>junk is a table with one column of type varchar(2).
 

>ORACLE:
>
>SQL> select * from junk;
>
>NAME
>-------------------------
>1
>2
>3
>4
>
>SQL> select * from junk where name not in ('1','2','');

SQL> select * from junk where name not in ('1','2'); should work.
I don't know if the '' was needed by sybase for some reason, but Oracle doesn't need it. Received on Mon Feb 06 1995 - 14:54:01 CET

Original text of this message