i have created cursor
how is updated new column in cursor
Printable View
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.
[B]>>i have created cursor.how is updated new column in cursor[/B]
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,[B]newcolumn[/B] FROM tablename;