Re: Help!! NewLine character in oracle string
From: Charles Jardine <cj10_at_cam.ac.uk>
Date: 1996/02/15
Message-ID: <312328F3.7F7E_at_cam.ac.uk>#1/1
Date: 1996/02/15
Message-ID: <312328F3.7F7E_at_cam.ac.uk>#1/1
Raj Rangarjan wrote:
>
> Hi,
> does anyone know what the new line character in an oracle varchar2
> variable is? I need to remove all occurances of the newline character from a
> string(using REPLACE) and I don't know what it is called in oracle( I tried
> using \n but apparently that is not what it is in an oracle.
Try REPLACE(mystring, CHR(10)) Received on Thu Feb 15 1996 - 00:00:00 CET