Hello,
Is there a way to have Toad auto generate a data insert statement? Here’s an example:
Table Users
PK,FirstName,LastName,FavSaying
1,‘John’,‘Smith’,‘Today is the day!’
2,‘Jane’,‘Brown’,‘Carpe diem’
3,‘Mark’,‘Johnson’,‘Just do it!’
So, looking at above table in Toad, I would like to select a row (or rows) and right click with the menu option to generate a data insert statement. Upon doing so, the following is put in an editor or the clipboard:
insert into Users values (FirstName,LastName,FavSaying) values (‘Jane’,‘Brown’,‘Carpe diem’)
If have two or more rows selected, it generates:
insert into Users values (FirstName,LastName,FavSaying)
select ‘Jane’,‘Brown’,‘Carpe diem’
union
select ‘Mark’,‘Johnson’,‘Just do it!’
Does Toad have such a tool? I looked for in 5.7 but no luck. I found something similar with the Export feature but it does a full select from the table. I just need the data with no reference to the source table.
Thanks,
Matt