Jobs in Pune | Work better in teams | Socialize with friends | Submit Q&A | Tell a friend

Search site for 

• What cursor type do you use to retrieve multiple recordsets?

   5,118 Views  |   (16 votes, avg: 3.44)

   Loading ...
    

Answers »

1. Submitted By: Anish — October 11, 2006 +2 votes   + -

   ref cursor can be used to retrieve and return the multiple records

3. Submitted By: Prashant — October 23, 2008 not yet rated   + -

   There are 3 types
   1. OPEN cursor_name
   2. FETCH cursor_name INTO var_name [, var_name]…
   3. CLOSE cursor_name

   Sample example (ONLY USED IN STORED PROC)

   DECLARE cur2 CURSOR FOR SELECT i FROM test.t2;
   OPEN cur2;
   FETCH cur2 INTO a, b;
   CLOSE cur2;

4. Leave an Answer/Comment

   Name (required)

   Mail (will not be published) (required)

   Your Answer

   To prove you're a person (not a spam script), type the security text shown in the picture. Click here to regenerate some new text.
   

Contact Us | FAQ | Sitemap | Terms of Use | Privacy Policy | Tell a Friend

Copyright © 1999-2006 Jeeve Technologies LLC. All rights reserved.