Re: carriage return / line feed's in text or varchar fields

Thanks, it is running now :-)

Rene Nyffenegger wrote:
>>Hi,
>>
>>I am writing some scripts which have to update data in an Oracle 8.1.6
>>database.
>>
>>The update commands are send by sqlplus
>>But I am unable to update text or varchar fields when the string
>>contains carriage return / line feed characters, because the CRLF's get
>>interpreted as part of the SQL statement (sp2-0734) instead of part of
>>the character string to be inserted. How do I get CRLF's into a text or
>>varchar field in Oracle?
>>
>>Thanks,
>>Andreas
>>
>>
>>i.e.:
>>
>>UPDATE contact SET field1='Hi,
>>
>>this is an update to test CR
>>
>>Greetings' WHERE ckey=4711;

> 
>  
> 
> update 
>   contact 
> set 
>   field1 = 'Hi,' || chr(13) || chr(10) || 'test'
> where
>   ckey = 4711;
> 
> 
> hth
> Rene Nyffenegger
>  
> 
>