Re: suppress the output of SQL's by spooling

"Guido Konsolke" <Guido.Konsolke_at_triaton.com> wrote in message news:<1051708977.948962_at_news.thyssen.com>...
> >
> > no! Imean teh complett string SQL> select 'aaa' from dual;
> (snip)

Sorry, didn't quite get it first time.
Look at Guido's solution, it should work. If not, then use the silent option to
call SQL*Plus. It takes away all formatting and displays nothing other than data.

> what if you invoke the commands from a script like
> '@spooltest.sql'?
> snip
> 3. Content of spooltest.txt
> aaa

Yup, that looks like what you wanted?

Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Wed Apr 30 2003 - 20:21:45 CDT