SQL Plus - dbms_output.put question
From: <psaf_at_dontspamme.memo.ikea.com>
Date: Tue, 8 May 2001 17:36:54 +0200
Message-ID: <9d93ms$cdi$1_at_mailgate.ikea.com>
[Quoted] comp_at_Compass CH >
comp_at_Compass CH >
1 begin
[Quoted] 2 dbms_output.put_line (' ksjksjdhksjh'); 3 end;
4 /
ksjksjdhksjh
Date: Tue, 8 May 2001 17:36:54 +0200
Message-ID: <9d93ms$cdi$1_at_mailgate.ikea.com>
Hello,
[Quoted] I would like to know if I can get SQL Plus to display the leading blank
spaces
in the examples bellow.
[Quoted] I want to extract formated DDL scripts but SQL Plus keeps throwing them away
[Quoted] Or is it just a default behavior and I can“t do anything about it.
[Quoted] [Quoted] I am using SQL PLUS version 3.3.4.0.0
Any hints?
Thanks
Pavel
[Quoted] comp_at_Compass CH >
comp_at_Compass CH >
1 begin
[Quoted] 2 dbms_output.put_line (' ksjksjdhksjh'); 3 end;
4 /
ksjksjdhksjh
PL/SQL procedure successfully completed.
comp_at_Compass CH > ED
Wrote file afiedt.buf
1 begin
2 dbms_output.put(' lksjdf');
3 dbms_output.put_line ('h');
4* end;
comp_at_Compass CH > /
lksjdfh
PL/SQL procedure successfully completed. Received on Tue May 08 2001 - 17:36:54 CEST