how to select random record from cursor

[pravin karne]

Hi,

i want to select random record from cursor

for example
CURSOR c1
IS
SELECT ADLIST
FROM SH_KEY_ADSLIST
WHERE CATEGORY=10 and AGE=-1 and TIME=-1
ORDER BY MO_NUM;

now cursor is contain 10 rows

now i want only one record from it but that should be random

another question is
can i find how many rows in the cursor are?

reply