This content has been marked as final. Show 6 replies
Execute the query in toad.
the data will display based on the query
right click on output data
select export data option
then select file type as insert statement.
give the schema name and table name in which table the data have to insert.
click on ok.
this is the way we can do in the toad for exporting insert stmt
Can any one advise me how to export the Update statement from toad or any other tool.(HereI don 't know if this will help, but SQL Developer does have this functionality,
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)
plus questions about it are relevant on the SQL Developer forum here.
SQL Developer is a fully functional free Oracle admin tool.