SQL & PL/SQL

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!

Trailing space is not removed after trimming

Andy FrédéricMar 28 2018 — edited Apr 26 2018

I run this query :

select trim(utl_raw.cast_to_varchar2((nlssort(d.det_entete, 'nls_sort=binary_ai')))) entete,

length(trim(utl\_raw.cast\_to\_varchar2((nlssort(d.det\_entete, 'nls\_sort=binary\_ai'))))) nb 

from details\_param\_import d join param\_import\_table p on d.param\_code = p.param\_code;

It gave this result :

So how to remove the trailing space ?

This post has been answered by Hans Steijntjes on Mar 28 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 18 2018

Added on Mar 28 2018

9 comments

1,496 views