DECLARE column1 varchar2 (20), column2 varchar2 (10), column3 number, cursor my_cursor is select column1,column2,column3 from table_1; BEGIN open my_cursor; fetch my_cusor into column1,column2,column3; while my_cusor % found loop
相反，虽然IDS SPL也支持类似的游标循环语句，但是不允许显式地声明、打开或关闭游标。
In contrast, IDS SPL supports a similar cursor looping statement but does not allow cursors to be explicitly declared, opened, or closed.
本文将从在ij工具内显式使用SQL游标开始讨论这两种方法。
This article discusses both methods, beginning with the explicit use of SQL cursors within the ij tool.
另一种方法是在ROLLBACK之后再次显式地打开游标，然后在ROLLBACK时把游标指针跳到读取的记录。
Another approach is to explicitly open the cursor again after ROLLBACK and skip the cursor pointer till the record read at the time of ROLLBACK.
应用推荐