Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

union/intersect vs. or/and semantics

659140Jun 2 2009 — edited Jun 2 2009
Hello...

I have non-correlated subqueries that are currently using or/and operators between each of the subqueries.

For example

sub_query_1
OR
sub_query_2

The questions are:

1. if I change the OR operator to an INTERSECT operator, does that return the same results?
2. Are the semantics of OR/INTERSECTS, AND/UNION the same?

Thanks,
Jim
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 30 2009
Added on Jun 2 2009
12 comments
1,902 views