SQL*Plus 系统变量之25 - HEADS[EP]

 HEADS[EP] {c|OFF|ON}

定义标题分隔符。此字符不能是数字字符或空格字符。可以在COLUMN命令或BTITLE和TTITLE命令中使用此字符使列标题或者报表标题显示为多行。当设为OFF时，把标题分隔符显示为普通字符。设为ON时将重置为默认的“|”字符。

SQL> set headsep +

SQL> column dname heading 'D+NAME'

SQL> select * from scott.dept;

 

             D

    DEPTNO NAME           LOC

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

        10 a"ccounting    new YOrK

        20 RESEARCH       DALLAS

        30 s<ales>        CHICAGO

        40 OPERATIONS     BOSTON

 

SQL> set headsep off

SQL> column dname heading 'D+NAME'

SQL> select * from dept;

 

    DEPTNO D+NAME         LOC

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

        10 a"ccounting    new YOrK

        20 RESEARCH       DALLAS

        30 s<ales>        CHICAGO

        40 OPERATIONS     BOSTON