bobmagan wrote:A misconception, I would say so.
For performance, is it best to surround the 'EXISTS' with an 'OR'? Is there a better way to do it?
To answer your original question, It is possible to use Multiple Exists in your query, provided those have an appropriate Conditional Operator amongst them.
create table test_table(col1 varchar2(1), col2 number); insert into test_table values ('A', 1); insert into test_table values ('B', 2); select col1 from test_table where col2 = 1 or col2 = 2; COL1 ---- A B