Hi,

My exact requirement in this query is, I wanted to display the results to the client application. It's like first 20,next 20 and so on. Now when i execute this query for the first time entire results(5000 rows) being return to client appln. but i am displaying 20 rows out of 5000. When user click on next 20, again i have to execute the same query, discard first 20 i'm displaying 20-40 records.

every time it returns entire result sets. Instead i wanted to return only 20 rows to the user.
I do not know about pl/sql table. i'm searching documents for that.

thanks