Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: is it possible 2 use IN(..) instead of c1 like 'a%' or c1 like 'b%'
isn't this the same as:
where c1 like 'a%' or c1 like 'b%'? why a union?
"damorgan" <dan.morgan_at_ci.seattle.wa.us> wrote in message
news:3C5EEE15.1A17E780_at_ci.seattle.wa.us...
> No. Try UNION or UNION ALL as in:
>
> SELECT *
> FROM mytable
> WHERE c1 LIKE 'a%'
> UNION
> SELECT *
> FROM mytable
> WHERE c1 LIKE 'b%';
>
> Daniel Morgan
>
>
>
>
> Steffen Ramlow wrote:
>
> > c1 in('a%','b%') does not work
> >
> > any suggestions?
>
Received on Tue Feb 05 2002 - 15:21:03 CST