Re: spooling problem

"Markus Innerebner" <markusin_at_yahoo.de> escribió en el mensaje news:2sf6m6F1iaiumU1_at_uni-berlin.de...
> hello i want to execute a spooling script with following problem:
> I do:
> 1) spool dropTables.sql
> 2) SELECT 'DROP '||object_type||' '||object_name||';' FROM user_objects
> WHERE object_type NOT like 'TABLE';
> 3) spool off
>
> when I no edit the file dropTables.sql i see following:
>
> more dropTables.LST
>
> 'DROPTABLE'||TABLE_NAME||'CASCADECONSTRAINTS;'
> --------------------------------------------------------------
> DROP TABLE VPROC__CHANNELS CASCADE CONSTRAINTS;
<snip>
> is it possible that the lines
>
> 'DROPTABLE'||TABLE_NAME||'CASCADECONSTRAINTS;'
> --------------------------------------------------------------
>
> are not written in the file?
>
> thanks
> best regards
>
> Markus Innerebner

Hello Marcus,
SET HEAD OFF will eliminate the column header and SET PAGES 0 will get rid of the blank lines in the listing.

From SQL*Plus you can check what settings are available by issuing HELP SET.

HTH
Anthony Hogan Received on Tue Oct 05 2004 - 05:17:18 CDT