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 | |
|---|---|---|---|---|
| sqlplus trimspool support | 4 | 1858 | October 22, 2010 | |
| Auto truncation of trailing space? | 3 | 2753 | September 5, 2014 | |
| toad 12.1.022 editor formatting problem | 5 | 988 | February 20, 2014 | |
| What settings to stop last field with right padding being trimmed | 2 | 751 | March 4, 2015 | |
| Toad adds blanks at the end of constant strings in results | 10 | 3010 | October 11, 2019 |