Re: Display all the records from table using cursor

[kaji Pasa]

I need to update the table A column A.a based on the value of a particular column from another table B column B.a .So i am trying to fetch all the rows from A (but now i am getting only first row), check if the value of the column A.a falls in the condition to update or not. If the column value needs to be updated, the update that column else move to next row.

For this requirement i am trying to create the cursor.