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