Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: newline in sql
In article <6js4qk$dpg$1_at_nnrp1.dejanews.com>,
adpctre_at_umassp.edu wrote:
>
> Hi,
>
> Can anyone tell me how to eliminate carridge returns in sql? I'm outputting
> a file using sql. One of the fields is varchar2(2000) and frequently
> contains carridge returns (hex '0D'). This is forcing the output to a
> separate record, which I don't want.
>
> What I'm thinking is to eliminate the CR in the output file, but I can't seem
> to find a way to do that. I tried translate(field,hextoraw('0D'),'something
> else'), but the hextoraw doesn't seem work at all.
>
> Thanks in advance.
>
Have you tried the replace function?
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue May 19 1998 - 11:32:35 CDT