After the decleration of the cursor with a where condition, how can i fetch each row which satisfies the condition ?
I have used this,
DECLARE CSR2 SCROLL CURSOR
FOR SELECT BROKER_ID,BROKER_DET
FETCH ABSOLUTE :N CSR2 INTO :HS-BROKER-ID, :HS-BROKER-DET
please suggest a fetch query