TOAD 14 Export Dataset is broken

Toad for Oracle
1

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

2

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.

3

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

4

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.