how to run the cursor loop once even if it is true for many times - urgent
536807Oct 10 2006 — edited Oct 10 2006Hi,
Say
loop
tdate='12-JAN-2005'
loop
cursor.......
if '10-JAN-2005'<=tdate then
fetch
...
..
end loop
tdate=tdate+1 month
end loop;
in the above query i want my cursor to run the loop only once at the first true of my condition....in the second run the tdate will be = '12-FEB-2005'....but my cursor loop should not go in..it has to comeout....
how to do this....plz help very urgent