Hi folks,
hopefully someone can answer this
When exporting resultsets as an SQL script any number > 1E14 is displayed in scientific notation
When the script is subsequently run the numeric data are corrupted and in my particular case checksum data trashed leading to two days of hand wringing
I have scripts that enforce a TO_CHAR with format string but working a little to stealthily I used PLD export as SQL and incurred a hit
I've scanned the documentation - is the numeric format down to Windows defaults or is there something I can set in preferences
If its not supported in preferences could I request an added feature to support this, either specifically as an export as SQL addition or numeric format in general - the former is likely more useful
Any help much appreciated
hopefully someone can answer this
When exporting resultsets as an SQL script any number > 1E14 is displayed in scientific notation
When the script is subsequently run the numeric data are corrupted and in my particular case checksum data trashed leading to two days of hand wringing
I have scripts that enforce a TO_CHAR with format string but working a little to stealthily I used PLD export as SQL and incurred a hit
I've scanned the documentation - is the numeric format down to Windows defaults or is there something I can set in preferences
If its not supported in preferences could I request an added feature to support this, either specifically as an export as SQL addition or numeric format in general - the former is likely more useful
Any help much appreciated
Last edited:
