LONG Column Question

From: Bhavesh Gosar <gosar_at_bhavesh.ebay.sun.com>
Date: 6 Mar 2000 23:19:17 GMT
Message-ID: <8a1edl$see$2@ebaynews1.EBay.Sun.COM>

Hi,

We have a Field which was a datatype with Varchar2(2000)...we used to Load data thru SQL*Loader into the Field applying the function "replace(:<field>,'^M','chr(10)||chr(13)')" This was due to the fact that Data came in thru the Web-form/email, etc and had a ^M....which we translated into the a New Line so that Data appears in proper format on the GUI Screen.

WE had a Business Requirement and Have to Change this Field to a LONG Field... How do we take care of the ^M replacement...since we cannot apply the replace function during or after the load of data....The Data without the above comes in one contiuous line...

Any help/pointer is appreciated.

TIA,
Bg Received on Mon Mar 06 2000 - 17:19:17 CST