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

Home -> Community -> Usenet -> c.d.o.server -> Exist

Exist

From: Sulejman Velic <sule_at_optima.ba>
Date: Fri, 10 Aug 2001 14:35:29 +0200
Message-ID: <9l0kj3$5iq7@ns4.bih.net.ba>

Hi all

I have the falloving query:

select *
from table1 a, table2 b
where a.column_1=b.column_1
and a.column_x in ('1','2','3','5','17','20')

Can I write this query usnig EXIST
instead of IN operator.

Thanx Received on Fri Aug 10 2001 - 07:35:29 CDT

Original text of this message

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