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!

Regular expression with newline in clob

npaiJul 31 2007 — edited Aug 3 2007
I have a clob that used end of line as chr(10).
But if chr(10) comes in a line enclosed by quotes it needs to be skipped and be replaced by nothing.
So the question is almost like this thread

1935617

But instead of looking for ',' I am looking for chr(10) between quotes.

If I use the regular expression in the above forum, I donot get the same result....

Any ideas?
Thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 31 2007
Added on Jul 31 2007
11 comments
1,718 views