cursor

[krishnaindia2007]

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.

[krishnaindia2007]

>>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;