Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Editing Nested table collection

805032Oct 13 2010 — edited Oct 14 2010
Hi,
We have a Nested table colletion which will contain around 500 rows of object type.
Now i need to update this table collection basing on the value of a column in object type.
Do i need to iterate through the collection using for loop and update the nested table or is there any other way using single Update command

"Update Table(<<nested_table>>) set <<something>> = value " doesn't work.

I am new to pl\sql and to collections, please help me with this.

Thanks in advance
Harsha
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 11 2010
Added on Oct 13 2010
13 comments
287 views