6 Replies Latest reply: May 9, 2012 9:03 PM by 875258 RSS

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

    875258
      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