Typing "man ascii" will give you the ascii character set in hex and
octal if you are in the Unix world.
Subramaniam, Sridhar wrote:
>
> try chr(10)
>
> Sridhar
> ----------
> From: owner-oracle-l
> To: Multiple recipients of list ORACLE-L
> Subject: Carriage Return chr(???) / new line chr(???)
> Date: Tuesday, 5 March 1996 4/52PM
>
> Does anyone know what's the number in chr(???) for carriage return
> ?
>
> declare
> message_line varchar2(100);
> begin
> message_line := 'LINE 1'||CHR(??)||CHR(??)||'LINE2';
> end;
>
> TIA
>
> ChorLing
>
> PS. Pls send your reply to chancl_at_nievax.nie.ac.sg
Received on Tue Mar 05 1996 - 09:25:08 CST
