Example SQL Script use Cursor

Here is a very very simple Oracle P-SQL script that uses a cursor to do some operation: SET SERVEROUTPUT ON   DECLARE CURSOR curMLPList IS SELECT DISTINCT IDENTITY FROM MLP_HEADER WHERE ROWNUM < 10 ORDER BY IDENTITY;   pid varchar(20); pver varchar(10);     BEGIN OPEN curMLPList; LOOP FETCH curMLPList into pid; EXIT WHEN curMLPList%NOTFOUND; […]