we export data from Toad Data Point 3.6.1 as delimited text and need for empty columns spaces (for post-processing an different systems).
A very simple example for showing the issue:
when we’re exporting the result of that SQL:
select ’ ’ from dual
select ’ a b ’ from dual
… then we’re getting a result like:
As you may see we do not use trim in the select but it automatically trims spaces.
When we take the SQL from Toad Data Point into Toad for Oracle everything works fine.
Any ideas why this happens?
Couldn’t find an option in TDA 3.6.1