stripping the first 2 lines from a spool file

[bi]

I am trying to write a sql script to pull data from a table and put it into a spool file. All I want in the file is the data.

The first two lines of the spool file contain the labels for the fields, followed by a line. Then the data starts.

How do I get those first two lines to NOT go to the spool file?

 

[bi]

Oh, and I also need the last line that tells how many rows were selected to not print to the spool file, either.

Thanks.

 

[ManjulaMadhu]

set feedback off
set pages 0

 

[BJCooperIT]

You will also need:

set head off

Consultant/Custom Forms & PL/SQL
Oracle 8.1.7 - Windows 2000

 

[bi]

When I type all three of those commands (set feedback off, set pages 0, set head off) I get this error:

MGR-00110: illegal SET option

Any other suggestions?

 

[lewisp]

Are you in a SQL*Plus session or something else?

 

[bi]

svrmgrl

 

[Turkbear]

Use SqlPlus instead...It has the added capabilities needed to do what you want, and it is the recommended method of accessing data. svrmgrl is being phased out...

 

[bi]

Thanks, Turkbear. That did it.

 

[cliousa]

SET HEADING OFF - will remove the column headings lines.


Hope that helps,

clio_usa - OCP DBA
------------------

http://www.dbaclick.com