SQL & PL/SQL

Hi,

I have a CLOB datatype and trying to remove all the extra trailing carriage returns from the column for all records in an update statement. Below is an example:

Row1: abc

cde
efg

Row2:afd
edg
Row3:wed

iek

Row4:okwq
wiekd
kdld

Output should be: (please note the trailing carriage returns of row1 and 3 are removed)

Row1: abc

cde
efg
Row2:afd
edg
Row3:wed

iek
Row4:okwq
wiekd
kdld

Below is the sample data. I'd like to run an update statement, that removes the trailing carriage returns(if exists) for each row. In the blow example, it should remove for the first record.

CREATE TABLE TEST_TRAIL (MYCLOB CLOB);


INSERT INTO TEST_TRAIL VALUES (
'Imports Core.Metadata


Inherits EntityFieldCustomization


End Class
');


INSERT INTO TEST_TRAIL VALUES (
'Imports Core.DataManager.Customization


Public Class DP_COMMENT_CHR
Inherits EntityFieldCustomization


End Class');

Using Oracle 11gR2, Windows7

Thanks