Re: SQL Plus - dbms_output.put question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 8 May 2001 18:49:12 +0200
Message-ID: <tfg8o9aa8148fa_at_beta-news.demon.nl>


[Quoted] [Quoted] This is a 'feature' both for sqlplus 3.3, 8.0 and 8.1

Hth,

[Quoted] Sybrand Bakker, Oracle DBA

<psaf_at_dontspamme.memo.ikea.com> wrote in message news:9d93ms$cdi$1_at_mailgate.ikea.com...
> Hello,
> I would like to know if I can get SQL Plus to display the leading blank
> spaces
> in the examples bellow.
> I want to extract formated DDL scripts but SQL Plus keeps throwing them
 away
> Or is it just a default behavior and I can“t do anything about it.
>
> I am using SQL PLUS version 3.3.4.0.0
>
> Any hints?
>
> Thanks
> Pavel
> --------------------------------------------------------------------------
 --
> ---------------------------------------
> comp_at_Compass CH >
> comp_at_Compass CH >
> 1 begin
> 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 - 18:49:12 CEST

Original text of this message