After creating INSERT statements from a result set using the Save as function in Toad 9.0.1, it results in unsolicited line feeds making the SQL invalid.
The "Save as" option has been used with the following settings:
- to Clipboard
- all rows / only selected rows (no difference in behaviour)
- INSERT Statements
- no include of schema name
- no include of NULL text
- no include of SQL Statement
- do not clone cursor
Issue fixed in version 9.1. The latest version of Toad for Oracle can be downloaded at: https://support.quest.com/download-product-select
