Dear all, After doing some SELECT operation on a TABLE, say we get 100 result items out of 1000 records, Is there any way where I can iterate through this result set. i.e., Get N items out of 100, say get previous 10, get next 10, etc,
This should be done without creating a temporary table or virtual tables. As there is overhead of space and time. If it is possible to use VIEWs then how can I? As I think VIEWs are little better than temp table or virtual table. Please correct me if I'm wrong. please reply, thanks in advance. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------