Incorrect SQL syntax is generated by Toad when exporting data containing NULL values as Insert Statements.
For example:
Locate a table that contains NULL data in any columns and export the data. In the Export Dataset window, choose the export format as "Insert Statements" and ensure the "Include null text" is un-checked.
The resulting Insert Statments for any NULL entries will be generated as such:
Insert into [TABLE_NAME]
)
Values
);
COMMIT;
WORKAROUND:
Ensure the option, "Include null text" is checked.
STATUS:
Waiting for a fix in a future release of Toad for Oracle.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center