Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Newbie cursor question
I have a cursor and I would like to do some data validation on each row in the cursor before the "real" processing begins. I would like to organize my as follows but am having problems finding the right language construct/reserved word.
for emp_record in cur_employees loop
if this row has a data problem then
continue onto next row in cursor end if
end
I can solve my problem by putting the "real" processing in the elsif part of the if statement, but the processing logic already involves three nested ifs and I don't want to indent them another level by putting them in the elsif.
Any ideas would be appreciated! Received on Thu Aug 10 2000 - 00:00:00 CDT