Replacing pattern by cr in longs

Hello !

Using Oracle server 7.3.x, I would like to replace a pattern (say '~~~') by a carriage return (chr(10)) but I can't use the REPLACE function because the field where I want to do this is of LONG type.

Has anybody an idea of how I could do this ?

Thanks in advance.

Benoit Received on Tue Dec 22 1998 - 10:40:13 CST