select * statement to delimited file

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.

set colsep ,
select * from ur_table;

Code:

---

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

---