SQL & PL/SQL

Hi All,

I need to "export" data for about 60 tables in one of my databases to a csv file format using a "|" as a separator.

I know I can do this using a query like:

select col1 || '|' || col2 || '|' || col3 from table;

Some of my tables have more than 50 columns so I'm guessing there is an easier way to do this than to construct select SQL statements for each table?

Thanks in advance.