Generating SQL statements from result sets
You can create INSERT, DELETE, and UPDATE statements for selected rows in the result set.
To generate SQL statements from an Interactive SQL result set
-
Select the row(s) you want to generate a statement for.
-
Right-click the selection, and choose Generate, and then choose INSERT Statement, DELETE Statement, or UPDATE Statement.
The statement is copied to the clipboard.