This content has been marked as final. Show 6 replies
this is a question on a 3rd party tool more so then an oracle question.
that said, can you elaborate further? An interested to see how do you export an insert statement?
"insert into table
whats to export?
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
ah, get you now, write a dynamic SQL to do the same thing as the update clause would be too cumbersome to wrap around I would have thought
select 'update table '....
then save the result set to a sql file.
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.
Possible sql*plus options could be spooling the output to txt file:
Select 'update (etc )'¦¦field1¦¦','¦¦...
The copy function available in some versions of sql*plus.
Thanks for your advice.