A ref cursor is a type that you can define in the declare section of your PL/SQL program. You can then open this cursor for any SQL statement that you construct dynamically in your program.

For your othr question of navigating to the 5th record, you can user a loop. Something like.

i:=1;

FOR cursor_rec IN cursor(...)

LOOP

IF (i=5) THEN

<do what you like >

ELSE

i:=i+1;

END IF;

END LOOP;

--

HTH,

Navin.