Skip to Main Content
Forums

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!

Appending data using Bulk Collect

805032Oct 18 2010 — edited Oct 18 2010
Hi,
Please let me know if there is any way to append data to a collection(nested table type) using bulk collect?

Ex: Select obj(userid) Bulk Collect into table_type from (Select user_id from users);

Now i want the new data to be appended to the data already present in table_type.

Thanks in advance
Harsha
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 15 2010
Added on Oct 18 2010
2 comments
10,951 views