By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,946 Members | 741 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,946 IT Pros & Developers. It's quick & easy.

getting tuples of result

P: 1
Hi,

Can anyone give any idea regarding how to read the result of execution of some query, tuple by tuple, from the backend, before it is sent to the client side?

for example, if the query is " select * from sometable; ", it is first parsed, and then send to the executor and then the final results are sent to the client side. Before this is done, the results of its execution must be present in some structure. Can anyone help me in finding out which is this structure and which is the function that enters the result tuples in to it?

~ raja
Nov 3 '07 #1
Share this Question
Share on Google+
1 Reply


amitpatel66
Expert 100+
P: 2,367
Hi,

Can anyone give any idea regarding how to read the result of execution of some query, tuple by tuple, from the backend, before it is sent to the client side?

for example, if the query is " select * from sometable; ", it is first parsed, and then send to the executor and then the final results are sent to the client side. Before this is done, the results of its execution must be present in some structure. Can anyone help me in finding out which is this structure and which is the function that enters the result tuples in to it?

~ raja
The three steps are PARSE,EXECUTE,FETCH.
Do you want to return the data record by record then you need to make use of a cursor.
Nov 5 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.