Re: Suppressing carriage returns inside a field.

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 08 Sep 1999 18:35:50 +0800
Message-ID: <37D63C06.93B@yahoo.com>

raymond garreau wrote:
>
> In my database, there is table with a field whose type is LONG.
>
> I would like to unload this table in file, but it doesn't work properly
> because of carriage returns have been typed in this field.
>
> Can someone tells me how to suppress carriage returns in a field.
>
> I can't do it manually since this table has 110 000 rows.
>
> Thank you.

chr(10) is the field you want to get rid of. Since its a long, you may need to write some pl/sql to

1. put the long col into a varchar2 (max 32767 bytes)
2. replace chr(10) will null
3. output the varchar2 (using utl_file probably)

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Sep 08 1999 - 05:35:50 CDT