存储过程,函数,游标（Stored procedures, functions, cursors）.docVIP

存储过程,函数,游标（Stored procedures, functions, cursors） A, the cursor The cursor is a PL/SQL control structure that can be explicitly controlled for the processing of SQL statements to facilitate the processing of the data of the table. Ps. When the amount of data in the table is large, it is not recommended to use cursors (inefficient and resource-consuming), but it can be flexible with the data method. The cursor is a recorded pointer, which is fed back to the record of the table by using the cursor to update or delete the activity set. Cursor properties: % FOUND, % NOTFOUND, % ROWCOUNT, % ISOPEN