Re: PL/SQL problem
From: Maarten Scharroo <m.scharroo_at_elsevier.nl>
Date: 20 Nov 1998 08:19:24 GMT
Message-ID: <01be145e$52dab9a0$7d0c2491_at_C30487.elsevier.nl>
Date: 20 Nov 1998 08:19:24 GMT
Message-ID: <01be145e$52dab9a0$7d0c2491_at_C30487.elsevier.nl>
Alvin Huang <dkualvin_at_tp.silkera.net> wrote in article
<01be1437$48ce77c0$c21141cb_at_421700.syscom.com.tw>...
> Hi,all
>
> I got a problem in PL/SQL
> how can I put an empty line ....
> I tried to use --- dbms_output.new_line,
> but it's useless
> is there any other functions that I can use to achieve the goal??
>
> Regards
>
> Alvin Huang,11/20
>
>
Alvin,
Writing a line concatenated with CHR(10) will do.
Try
SET SERVEROUTPUT ON
BEGIN
dbms_output.put_line('Line 1'||CHR(10));
dbms_output.put_line('Line 3');
END;
/
And see what happens.
Maarten Scharroo Received on Fri Nov 20 1998 - 09:19:24 CET