CODEWITHSUNDEEP
sqloracle-databaseoracle11g
radhika
radhika

Reputation: 87

multiple line clob

I have a CLOB column and every value in clob value spans multiple lines and some of the lines are blank.

Example of the data:

abcd
ihuj

lkijhhusd
jjjjj

Now I want to write a query which will generate abcd;ihuj;lkijhhusd;jjjjj

Upvotes: 0

Views: 489

Answers (1)

Stavr00
Stavr00

Reputation: 3314

REGEXP_REPLACE(my_clob,'[\r\n]+',';',1,0,'m')

http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions130.htm

http://perldoc.perl.org/perlre.html

Upvotes: 1

Related Questions