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!

check if record exist in two tables

944524Sep 9 2015 — edited Sep 9 2015

Hi,

I am having two tables below where i need to check if any record present in either of two tables proceed something like this

select count(*) into cnt from T1 where rownum=1

select count(*) into cnt_1 from T2 where rownum=1


if cnt or cnt_1 > 0 then

proceed

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 7 2015
Added on Sep 9 2015
10 comments
3,060 views