select * statement to delimited file

[brado]

I've been trying to find information on how to convert a tesxt file that was a result of a select * statement into a delimited file. I haven't been able to find anything that didn't require me to type each fiel into the query. Does anyone have a simpler method of performing this task? I saw an example that said to set colsep '|'
before the select statement, but that didn't break the filed up into the proper columns. Thanks in advance.

[Shestakov]

set colsep ,
select * from ur_table;

SQL> set colsep ,
SQL> select * from all_users;

USERNAME , USER_ID,CREATED
------------------------------,----------,---------
SYS , 0,16-APR-01
SYSTEM , 5,16-APR-01
TRACESVR , 19,16-APR-01
OUTLN , 11,16-APR-01
DBSNMP , 16,16-APR-01