Skip to Main Content

Oracle Database Discussions

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!

Toad exports query result as UPDATE stmt or export the update stmt

875258May 8 2012 — edited May 9 2012
Hi,

Can any one advise me how to export the Update statement from toad or any other tool.(Here having a big number of record that have export from instance and run as a script in the another instance so that the all records will update at once)

Example:

In toad, we can export the insert statement from export data option.
similarly can we export the update query from toad or any other tool or have any procedure that generates the update statement.
Thanks a lot,
Sree
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 6 2012
Added on May 8 2012
6 comments
1,243 views