spooling question

[lesstjm]

when I do a spool to a file I set the header off first because I don't want the header. The problem that am running into is that it the spool file oracle is putting a return character on the first line and then it is putting the output after that. Is there a way to either get oracle not to put the return character in the first line or after the file is created mv it in unix to another file without the first line? Any help would be appreciated.

[nealh]

You should also do a "set pagesize 0" to stop Oracle putting a blank line in wherever it thinks there is a new page.

[lesstjm]

your a genius. thank you. set pagesize 0 works.