Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Carriage Return chr(???) / new line chr(???)
try chr(10)
Sridhar
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
ChorLingPS. Pls send your reply to chancl_at_nievax.nie.ac.sg Received on Mon Mar 04 1996 - 19:29:06 CST
![]() |
![]() |