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!

How to find carriage reutrn in a column

SmileMay 23 2011 — edited May 24 2011
Hi,
I've a column which has a value consisting of carriage return at the end

The following query did not work to find out the CR
select org,handle,length(org) from peson where regexp_like(org,'(^ | $)');
Regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 21 2011
Added on May 23 2011
7 comments
617 views