Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to trim trail space in query output on 11.2.0.4 Oracle Database

Chandan BhagatFeb 6 2018 — edited Feb 6 2018

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 6 2018
Added on Feb 6 2018
17 comments
463 views