Generating SQL statements from result sets in Interactive SQL

You can create INSERT, DELETE, and UPDATE statements for selected rows in the result set.

 Generate SQL statements from an Interactive SQL result set
  1. Select the row(s) you want to generate a statement for.

  2. Right-click the selection, and click Generate, and then click INSERT Statement, DELETE Statement, or UPDATE Statement.

    The statement is copied to the clipboard.