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!

execute other query if not data found.

user021Dec 18 2017 — edited Dec 18 2017

Dear,

I just want to understand how to do this through sql query, is there any oracle new features for select statement if first query is failed then get result from another query.

Let's suppose i search deptno 50 in the dept table if no data exist then it execute another query.

Pls advise.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 15 2018
Added on Dec 18 2017
7 comments
2,701 views