sql statement - comma delimited file

Can a sql statement be used to generate a comma delimited file in Oracle?

This is pretty urgent.

Thanks

You can do something like this:

> desc t1
Name Null? Type
------------------------------- -------- ----
A VARCHAR2(10)
B VARCHAR2(10)
C VARCHAR2(10)

> select a || ',' || b || ',' || c from t1;

A||','||B||','||C
--------------------------------
a1,a2,a3
b1,b2,b3
c1,c2,c3

You could spool the output to a file.

--
Paul

Or you can "SET COLSEP ," in SQL*Plus and just SELECT * FROM ...

Ales

Thanks