cursor

[priyasp_msit]

i have created cursor

how is updated new column in cursor

[krishnaindia2007]

Your question is not clear.

Do you want to update a column?

[debasisdas]

for what you have created the cursor ?

[priyasp_msit]

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

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