Skip to Main Content

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!

mutually exclusive query

RengudiJul 9 2012 — edited Jul 9 2012
Hi

I have two queries
Query 1:-

SELECT DTN
      FROM tabA
    WHERE INSTANCE_ID = 123 AND PROCESS_ID = p123

Query:-2

SELECT DTN
          FROM tabB
    WHERE INSTANCE_ID = 123 AND PROCESS_ID = p123
Whenever no data found on result set of query1 then query2 to executed and vice-versa.

How it can be achieved in a single query..?

Thanks
Raj
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 6 2012
Added on Jul 9 2012
21 comments
1,894 views