generate CSV

Hi,

simple SQL question for you:
how can I generate a csv file from a table in oracle ?

something like:
set head off
set feed off
select col1||';',col2||';'... from table_name ;

the columns are in several lines , not one line I have problem with col format I think

How can I do that ??

Thanks Received on Sat Mar 23 2002 - 04:06:05 CST