SQLCL Delimited format- Pipe

I have a requirement to export an extremely large file using the pipe delimiter.

I find that for extremely large files, SQLCL works much better than SQLDeveloper, in that, it doesn't crash or hang ;-).

It's a pretty good tool in many other ways, but I digress.

I see a /*delimiter*/ option for SQLCL but I don't know how to set the delimiter to pipe in SQLCL.

See this link for an explanation of the formats available using a 'comment' in the query

http://www.thatjeffsmith.com/archive/2012/05/formatting-query-results-to-csv-in-oracle-sql-developer/

Using the loader format is close to what I need but it leaves out the headings and I'm loathe to add another query just for headings due to the nature of what I'm doing. 

I don't understand that at all. What does 'the nature' of what you are doing have to do with it?

Adding a simple query to get the headers is SIMPLE compared to unloading large amounts of data without error. You only need the headers once so you can easily store them in a file and just concatenate that one line file eveytime you export.

>>I see a /*delimiter*/ option for SQLCL but I don't know how to set the delimiter to pipe in SQLCL

You can't. If you want to change up the delimiter, it's back to SQL Developer. So not to go off-topic, but I'd like to help you get it working there as well. If it's hanging or crashing - two very different things - we should find out why and make sure it's not a bug.