Is there an Oracle SQL tool that builds insert statements from a result set?

Question

Is there an Oracle SQL tool that builds insert statements from a result set? We are currently only allowed to use a tool called SQL Station. I'd like to either suggest a tool, like Rapid SQL or CrazySQuirrell, or build my own re-usable chunk of sql.

Answer 1

Where is this result set coming from? If you mean that you want to execute a SELECT, then insert the resulting data into another table, you can do that in a single SQL statement:

INSERT INTO table2 (columnA, columnB)
  SELECT columnA, columnB
    FROM table1;