Skip to Main Content
Forums

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!

remove leading/trailing spaces on CLOB

Douglass DavisNov 4 2010 — edited Nov 4 2010
Is there any function to remove leading/trailing spaces on a clob. I noticed there is a dbms_lob.TRIM but it's not the same as TRIM. If not, can any one recommend a way to do this?

Version Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

More about this: what I am trying to do is see if one trimmed clob value is equal to another trimmed clob value.

Thanks
This post has been answered by odie_63 on Nov 4 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 2 2010
Added on Nov 4 2010
2 comments
7,090 views