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>
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