SQL> set colsep ','
SQL> desc tab
名称
是否为空? 类型
----------------------------------------- -------- ------------
TNAME
NOT NULL VARCHAR2(30)
TABTYPE
VARCHAR2(7)
CLUSTERID
NUMBER
SQL> select * from tab where rownum spool c:\a.csv
SQL> select * from tab where rownum spool off