Suppose if I need to update a column, how you do that using cursor?

Suppose if I need to update a column, how you do that using
cursor?

Question Posted / khbnaidu

2 Answers
7010 Views
Verizon, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Suppose if I need to update a column, how you do that using cursor?..

Answer / bobby

continuation of previous answer,

after cursor declaration, open the cursor and fetch the cursor. When the condition for update is satisified isue EXEC SQL UPDATE CURRENT OF.

Is This Answer Correct ?

6 Yes

0 No

Suppose if I need to update a column, how you do that using cursor?..

Answer / sandy

EXEC SQL DECLARE X CURSOR FOR
SELECT * FROM ABC
FOR UPDATE OF <COLUMN> ==>If we know the column we would
like to update.

Is This Answer Correct ?

4 Yes

0 No

Post New Answer