Exporting/spooling data to a text file

I'm having trouble exporting data to a text file. I've tried spooling it from SQL*Plus, but we have one table with a Varchar2(2000) field and it keeps wrapping it. SQL*Plus also keeps inserting page breaks, although I'm pretty sure I can get rid of those. (I think I remember seeing a command to set the page length and I'm sure that if I just keep looking then I'll find it again. I assume that it will allow an infinite page length but if not then that'll be another problem.)

I'd like to end up with either fixed length or delimited fields, one record per line.

I suppose I could write a 'report' program, but that seems like building a ladder because you can't get the door to the stairs open. Any ideas? Received on Wed Dec 15 1999 - 15:11:45 CST