Search code examples
oracletoadsql-navigator

Oracle script client that exports query result as UPDATE statement

I use Quest TOAD for Oracle and Quest SQL Navigator for Oracle as my database query tools of choice.

These tools allow me to export the query results grid as INSERT statements.

For example 

SELECT dummy  
FROM dual;

exports to 

INSERT INTO dual
(DUMMY)
VALUES
('X')
/

Is there an Oracle database query tool that exports query results as UPDATE statements?

For example 

SELECT dummy  
FROM dual;

would export to 

UPDATE dual
SET dummy = 'X'
/
Solution

  • Try this one: http://www.sql-workbench.net