Export as insert

[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.

Eg:

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!

Regards,

[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.