Welcome to Questionaries, where you can ask questions and receive answers from other members of the community.

Let us know at info@questionaries.org

What WHERE CURRENT OF clause does in a cursor?

5 like 0 dislike
asked 1 year ago by marck_don (191,010 points)

1 Answer

1 like 0 dislike
 
Best answer
LOOP
SELECT num_credits INTO v_numcredits FROM classes
WHERE dept=123 and course=101;
UPDATE students
FHKO;;;;;;;;;SET current_credits=current_credits+v_numcredits
WHERE CURRENT OF X;
answered 1 year ago by daneim (127,080 points)

Related questions

7 like 0 dislike
1 answer
5 like 0 dislike
1 answer
asked 1 year ago by rad_joshep (19,390 points)
5 like 0 dislike
1 answer
5 like 0 dislike
1 answer