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!

regular expression help - need to find the carriage return

Mac_Freak_RahulAug 26 2016 — edited Aug 27 2016

Hi,

My oracle db : 11G

sample data:

with t as

(select 'xyz' c1 from dual union all

  select 'xyz abcf

  efgh' from dual union all

  select '123' from dual )

select *

from t

Hi,

lets say I have 3 rows in column 'c1' of my table 't' and now I want to find out if there is a row where there is a carriage return or not, I am not able to figure out, please help me out.

PS: my output should be my 2nd row only where indeed there is a carraige return

Thanks

Rahul

This post has been answered by Hans Steijntjes on Aug 26 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 23 2016
Added on Aug 26 2016
19 comments
3,969 views