In Toad v14, Export Dataset doesn't include some NULL fields if the 'Display large numbers if scientific notation' option is unticked.
On an Export Dataset to clipboard (or file) of a select on a table with several NULL fields, sometimes some separators are missing, so some data is shifted in Excel. This doesn't happen in v13.3, but is seen in v14.
Steps
=======================
Untick the scientific notation option, then:
1.
create test table:
CREATE TABLE WMC (a number, b number, c number, d varchar2(10));
INSERT INTO wmc VALUES(NULL, NULL, NULL, 'LINE 1');
INSERT INTO wmc VALUES(NULL, NULL, NULL, 'LINE 2');
INSERT INTO wmc VALUES(NULL, 3, NULL, 'LINE 3');
INSERT INTO wmc VALUES(4, NULL, NULL, 'LINE 4');
2.
SELECT * FROM wmc
3.
Then do Export Dataset on the resultset (export to clipboard, but same problem happens to file)
4.
Paste results in Notepad:
A;B;C;D
LINE 1
LINE 2
3;LINE 3
4;LINE 4
If you check "include null text" in Export Dataset options, it is ok.
A;B;C;D
null;null;null;LINE 1
null;null;null;LINE 2
null;3;null;LINE 3
4;null;null;LINE 4
=======================
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center