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>


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

Original text of this message