I just upgraded from Toad/Oracle 10.5 to 11.6 and noticed a change in behavior where, when spooling to a file, trailing spaces are being truncated from the last column in the query, in this case a varchar2(100) column. In Toad 10.5 the column was always spooled w/ 100 characters. In Toad 11.6 it is truncated to the length of the string in the field. I would like to restore the previous behavior if possible. Thanks in advance for your assistance.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Auto truncation of trailing space? | 3 | 2706 | September 5, 2014 | |
| Sql output with a space and NULL in the output | 7 | 953 | December 9, 2021 | |
| sqlplus trimspool support | 4 | 1795 | October 22, 2010 | |
| What settings to stop last field with right padding being trimmed | 2 | 725 | March 4, 2015 | |
| Toad 12.5 Session Browser, Current Statement: Sql is truncated | 9 | 3659 | May 27, 2015 |