Export as insert

Feature requests and their debate

Export as insert

Postby marcinhom » Wed Jan 20, 2016 11:44 am

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,
marcinhom
 
Posts: 10
Joined: Wed Jun 03, 2015 2:36 pm

Re: Export as insert

Postby Serge » Thu Jan 21, 2016 4:40 pm

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.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb


Return to Feature Requests



Who is online

Users browsing this forum: No registered users and 3 guests