/* Formatted on 2011/11/26 11:42 (Formatter Plus v4.8.8) */ DECLARE row_id PLS_INTEGER; v_batch_id temp.batch_id%TYPE; v_slab_id temp.slab_id%TYPE; flag NUMBER (2); num PLS_INTEGER := &row_id; CURSOR c1 IS SELECT batch_id, slab_id FROM temp; BEGIN OPEN c1; LOOP FETCH c1 INTO v_batch_id, v_slab_id; DBMS_OUTPUT.put_line (v_batch_id || ' ' || v_slab_id || flag); flag := 1; EXIT WHEN c1%ROWCOUNT > (num-1); END LOOP; CLOSE c1; END;