Invalid script created when generating Insert Statements using the Export Data functionality</ (4246970)

Chat now with support

Return

Title

Invalid script created when generating Insert Statements using the Export Data functionality
Description

When exporting data (insert statements) from a table which includes ‘default ' ' not null,’ in the DDL, the statements are not created correctly. When you try to run the script into the table, it is unsuccessful as the spaces in the null values are incorrect.
1. In the editor, run:   select table_name.*,rowid from table_name;
2. Click the ‘Export Data’ button.
3. Export format = ‘Insert Statements’
4. Tick ‘Display all results in grid’
5. Untick ‘Include Null Text’
6. Export the data
In the resulting script, the null values appear as follows, with no spaces in the null entry:

Insert into TABLE_NAME
   (C1, C2)
Values
   (4613225644, '');

The null value is ‘’, that causes an error when you try to run the generated script into the table.

If ‘Include Null Text’ is ticked, and ‘Display all results in Grid’ is unticked, then the null value is generated correctly, with spaces for the null entry:

Insert into TABLE_NAME
   (C1, C2)
Values
   (4613225644, '          ');

However, it doesn't necessarily make sense to tick the ‘Display all results in grid’ option, and also this didn’t happen in Toad 10.5.

Sign In Required

You need to be signed in and under a current maintenance contract to view premium knowledge articles.