-
Contributing Member
cursor
i have created cursor
how is updated new column in cursor
-
Expert Member
Re: cursor
Your question is not clear.
Do you want to update a column?
-
Re: cursor
for what you have created the cursor ?
-
Contributing Member
Re: cursor
this is interview qns.
they said that already created cursor using procedure then after i will add new column
how?
-
Expert Member
Re: cursor
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.
-
Expert Member
Re: cursor
>>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;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules