Comma separated file

Given a table, is there any way of extracting the data and create a Comma-separated ASCII text file ?
I tried using the following .....

SQLPLUS > SPOOL TEST.DAT
> set pagesize 0
> select COLA || ',' || COLB || ',' || COLC from
TEST_TAB ...but I am sure there should be a better way of doing this as this method doesn't properly get
some of the datatypes like DATE, CLOB, etc.

Thanks
Murty Received on Mon Jul 15 2002 - 18:25:38 CDT