Page 1 of 1

Export as insert

PostPosted: Wed Jan 20, 2016 11:44 am
by marcinhom
Hi Guys,

I'm here again to suggest another very interesting thing! This resource is available on Toad and is very important to do backups.

The feature is, create a INSERT statement for the rows and columns that return from query.


Select name, adress, phone from customer where city = 'New York';

We will got all customers that's live on New York and create a insert statement using the result, like this:

insert into customer values (column1, column2, column3);

Thank you again!


Re: Export as insert

PostPosted: Thu Jan 21, 2016 4:40 pm
by Serge
This feature is already implemented.
You can export a table (right click on table -> Export data) or resultset (right click -> Export results). Then choose "Export to SQL INSERT statements" format and voila.