设置sqlplus输出数据的分割符

SQL> set colsep ","
SQL> select object_id,object_name from all_objects where rownum<2;

OBJECT_ID,OBJECT_NAME
----------,------------------------------
20,ICOL$

SQL> set colsep "|"
SQL> select object_id,object_name from all_objects where rownum<2;

OBJECT_ID|OBJECT_NAME
----------|------------------------------
20|ICOL$

SQL> set colsep " "
SQL> select object_id,object_name from all_objects where rownum<2;

OBJECT_ID OBJECT_NAME
---------- ------------------------------
20 ICOL$

SQL> set colsep test
SQL> select object_id,object_name from all_objects where rownum<2;

OBJECT_IDtestOBJECT_NAME
----------test------------------------------
20testICOL$

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/193161/viewspace-50166/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/193161/viewspace-50166/