Make use of CHR(13)

declare
begin
dbms_output.put_line('A'||chr(13)||'B');
end;
/

-----Original Message-----
From: Muir Ross-IT-WRM044 [mailto:[Email Address Removed] Wednesday, March 31, 2004 2:28 PM
To: LazyDBA.com Discussion
Subject: SQL Format question


Quick question does anyone know the best way using PL/SQL to force output
from a query onto a new line?

Ross






Oracle LazyDBA home page