Originally posted by hrishy
Hi

well imagine that your remote table contains a million rows..so will the cursor fetch million rows and insert it into the local buffer cache nope..this is not true..it will return the first rows as quickly as possible..
regards
Hrishy
Okay. Anyway, the answer the original question is that it doesn't go to the remote server for each fetch.