|
-
Go to Next Record in For Loop
I want to know how to go to the next record in a for loop if a column in a record equals a certain value. For example
declare
cursor c1 is
select * from mytable;
begin
for v1 inc1 loop
if v1.mycolumn = 'A' then
< here is where I want to tell it to go to the next record >
end if;
v1.mycolumn = 'R';
end loop;
end;
/
Can I use some type of break command.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|