DECLARE Cursor c; id int; BEGIN LOOP --Initialize cursor with similar query but distict where using the id variable. --Cursor loop to process data END LOOP END;
DECLARE id int; BEGIN LOOP -- id = new_value; FOR X IN (SELECT * FROM T WHERE T.ID = ID) LOOP -- Process data. END LOOP; END LOOP; END;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)