Hello,
We are observing the query resulted in trail spaces in the output of any query on database, we compare the same on 2 database of same version 11.2.0.4 and the result is different. Please suggest how to overcome this situation. Is there any parameter which will rectify this?
----Working as expected------
SQL> select '123' as coll from dual;
COL
---
123
----Not Working------
SQL> select '123' as coll from dual;
COLL
--------------------------------
123