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