When the agregate functions SUM, COUNT, AVG, MAX and MIN are run from ISQL when connected as dialect 3, a column header is not displayed.
Example 1 (column header shown for dialect 1):
SQL> set sql dialect 1;
SQL> select sum(f1) from foo;
SUM
============
21
Example 2 (column header not shown for dialect 1):
SQL> set sql dialect 3;
SQL> select sum(f1) from foo;
=====================
21
Last Modified: 07-FEB-01