467,154 Members | 881 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,154 developers. It's quick & easy.

fetch cursor

plz tell the need of fetch
Sep 6 '07 #1
  • viewed: 2697
2 Replies

Cursors are used when more than one row from the table needs to be processed.
The Open cursor will get the filtered records from the table.
Fetch command will move the values from the table to the Host variables which can then be used in the host language program.

Declare Cursor (non executable statement)
Open Cursor (Get the records)
Fetch (Move values to Host Variables for one row at a time. the pointers to handle the next row is handled by Host Language)
It is only possible to fetch records in forward direction. you cannot go backward or to a previous record with cursors
Finally Close the cursor.


plz tell the need of fetch
Sep 7 '07 #2
Hi Harish,

Sep 10 '07 #3

Post your reply

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

Similar topics

3 posts views Thread by robert | last post: by
2 posts views Thread by TA | last post: by
1 post views Thread by traceable1 | last post: by
2 posts views Thread by satishchandra999@gmail.com | last post: by
reply views Thread by debasisdas | last post: by
7 posts views Thread by Frank Swarbrick | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.