Creating a delimited text file with SQL*Plus / PL/SQL

I need to create a vertical bar delimited (|) text file from within a SQL script or PL/SQL block. I am more <<systems>> than DBA, but am stuck with some of these interface duties. I could easily do it by doing a generic text output from SQL*Plus to a file and massaging it from there with C or Pascal, but I want to make this a single step process.

I already have to massage the data from PL/SQL to solve other problems, so I don't want to bore you with that. After I finish that, the table will be ready to export in its entirety. All I need is all fields, one row per line, each field separated by a | (or comma, or whatever).

Any help anyone could provide would be greatly appreciated. Response by email would be even better!!

Terry Porter
t_porter_at_ix.netcom.com Received on Sat Mar 23 1996 - 00:00:00 CET