i have created cursor

how is updated new column in cursor

Your question is not clear.

Do you want to update a column?

for what you have created the cursor ?

this is interview qns.
they said that already created cursor using procedure then after i will add new column
how?

If you add a new column or make modifications in table structure then all the dependent objects will become invalid. You have to recompile all dependent objects.

>>i have created cursor.how is updated new column in cursor

Still your question is not clear.

To add a new column in your cursor definition just include that column name in cursor definition.


CURSOR C1 is
SELECT column1,column2,newcolumn FROM tablename;