Toad World® Forums

TOAD 14 Export Dataset is broken

I am having trouble using "Export dataset" feature in TOAD 14.0.75.662.
If there are two null following null value columns in a row, TOAD 14 does not export the row with the correct number of delimiters.

Example:
SELECT 1 as row_number, 1 as col1, 'One' as col2, 1.1 as col3 from dual
union
SELECT 2 as row_number, null as col1, '' as col2, 2.2 as col3 from dual
union
SELECT 3 as row_number, 3 as col1, 'Three' as col2, null as col3 from dual
union
SELECT 4 as row_number, 4 as col1, '' as col2, 4.4 as col3 from dual
order by 1

TOAD 14 exports (using Pipe delimiter)

"ROW_NUMBER"|"COL1"|"COL2"|"COL3"
1|1|"One"|1,1
2||2,2
3|3|"Three"
4|4||4,4

So in row_number 2 the value of COL3 is put into COL2.

TOAD 13 correctly exports this:

"ROW_NUMBER"|"COL1"|"COL2"|"COL3"
1|1|"One"|1,1
2|||2,2
3|3|"Three"|
4|4||4,4

Thanks. This got reported through support recently.

This only happens when:

  • Format is "Delimited Text" option,
  • "Scientific Notation" is unchecked
  • "Include null text" is unchecked
  • "Number Quoting" is set not set to one of the "including nulls" choices

You can change any of the above for a workaround.

We'll have it fixed soon in beta. Sorry about that.

Hi John,
thank you for sharing the information.
I will continue using TOAD 13 for these exports until the availablility of the bug fix.

Best regards, Volker

Fixed in the current beta, which you can get here. Toad for Oracle 14.1 Beta

A change log is in the comments section of that link.