Re: escape characters in CLOB variables
From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 16 May 2003 12:28:09 -0700
Message-ID: <92eeeff0.0305161128.2d2dfb36_at_posting.google.com>
Date: 16 May 2003 12:28:09 -0700
Message-ID: <92eeeff0.0305161128.2d2dfb36_at_posting.google.com>
gunyo_at_ludens.elte.hu wrote in message news:<Ad36NsJRDEdA_at_ludens>...
> Yet another question...
> Is there a way to store newlines, etc. in CLOB or varchar variables, like using
> \n or \t in C++? Or must the whole CLOB be one long, long line?
>
> Thx
In Oracle, you can embed an ASCII value of a character in a VARCHAR or CLOB. ASCII value of LF (linefeed) is CHR(10).
string_ := '123 Any Street' || CHR(10) || 'Any Town ZZ, 99999';
Regards
/Rauf Sarwar
Received on Fri May 16 2003 - 21:28:09 CEST