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!

if -else condition in cursor

856037Jun 9 2011 — edited Jun 9 2011
Hi,

I want to write a if-else condition in cursor.i.e.
cursor c1 is
if par=1 then
select * from tab1;
else
select * from tab2;

can anyone help me on this?

Edited by: user12288167 on Jun 8, 2011 11:49 PM
This post has been answered by Mahir M. Quluzade on Jun 9 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 7 2011
Added on Jun 9 2011
8 comments
21,814 views