Re: Stripping of spaces in SQL Plus

From: Igor Chernysh <igor_at_ios.com>
Date: 1997/03/29
Message-ID: <333D429A.361C@ios.com>#1/1

Hi,

> You may want to use DBMS_OUTPUT package. I's much more flexible way to
> write to a file then spooling from SQL*Plus. See Oracle7.3 Server
> Developers Guide.

Another problem here:

   dbms_output.put_line and dbms_output.new_line ,

they are trim leading spaces. :) At least, with RDBMS 7.1.6

But you still can use the trick if you need indents:

	dbms_output.put('something');  -- in previous line
        dbms_output.put(chr(10)||'   anything, supposed to be

indented');

That's something.

WBW, Igor. Received on Sat Mar 29 1997 - 00:00:00 CST