Skip to Main Content

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!

Issue with Oracle Trim Function

JodySep 26 2016 — edited Sep 26 2016

I have a varchar2(4 bytes) column in the database. Though the data in the column has 4 characters the length() function returns 5 even with the Trim(). Any direction to reduce the length from 5 to 4 will be appreciated.

Thanks

This post has been answered by mathguy on Sep 26 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2016
Added on Sep 26 2016
12 comments
1,669 views