问题描述如下:
SQL> conn scott/tiger
Connected.
SQL> select * from dept;
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
SQL> show heading
heading ON
heading环境变量已设为on, 但是标题仍然无法显示。一开始以为,是自己的数据库装得有问题,重装了一遍,问题还是一样,
上网搜了下,是pagesize环境变量的问题。当pagesize=0时,除了不分页,同时,也不会显示列标题
SQL> conn scott/tiger
Connected.
SQL> select * from dept;
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
SQL> show heading
heading ON
SQL> show pagesize
pagesize 0
SQL> set pagesize 5000
SQL> select * from dept;
DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON