===========================================================
使用别的分割符号
===========================================================
作者: lfree(http://lfree.itpub.net)
发表于: 2005.05.08 10:21
分类: oracle
出处: http://lfree.itpub.net/post/4950/28884
---------------------------------------------------------------
发表于: 2005.05.08 10:21
分类: oracle
出处: http://lfree.itpub.net/post/4950/28884
---------------------------------------------------------------
摘自：
http://www.itpub.net/356687.html
scott@ORCL> set colsep ','
scott@ORCL> select * from dept ;
DEPTNO,DNAME ,LOC
----------,--------------,-------------
10,ACCOUNTING ,NEW YORK
20,RESEARCH ,DALLAS
30,SALES ,CHICAGO
40,OPERATIONS ,BOSTON
http://www.itpub.net/356687.html
scott@ORCL> set colsep ','
scott@ORCL> select * from dept ;
DEPTNO,DNAME ,LOC
----------,--------------,-------------
10,ACCOUNTING ,NEW YORK
20,RESEARCH ,DALLAS
30,SALES ,CHICAGO
40,OPERATIONS ,BOSTON
