SQL*Plus 系统变量之39 - RECSEP

RECSEP {WR[APPED]|EA[CH]|OFF}

设置是否及何时显示或打印记录分隔符。

[WRAPPED]：只有记录行被自动换行时才显示记录分隔符。

[EACH]：在每行记录的下一行显示记录分隔符。

[OFF]：不显示记录分隔符。

SQL> set recsepchar +

SQL> set recsep each

SQL> select * from scott.dept;

 

    DEPTNO DNAME          LOC

---------- -------------- -------------

        10 a"ccounting    new YOrK

+++++++++++++++++++++++++++++++++++++++

        20 RESEARCH       DALLAS

+++++++++++++++++++++++++++++++++++++++

        30 s<ales>        CHICAGO

+++++++++++++++++++++++++++++++++++++++

        40 OPERATIONS     BOSTON

+++++++++++++++++++++++++++++++++++++++