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.
Untick the scientific notation option, then:
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');
SELECT * FROM wmc
Then do Export Dataset on the resultset (export to clipboard, but same problem happens to file)
Paste results in Notepad:
If you check "include null text" in Export Dataset options, it is ok.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.