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