substr to trim headings

From: <jfedock_at_ixl.com>
Date: Fri, 5 Jan 2001 14:07:28 -0500
Message-Id: <10732.125872@fatcity.com>

Anyone know why my headings do not get trimmed when using substr from the SQLPLUS client on my PC.
It does work in SQLWorksheet and in the Unix server sqlplus. It happens on sqlplus client 8.0.5 and 8.1.5  

For example:  

HEADING IS NOT TRIMMED.   SQL>select substr(username, 1, 15) NAME
  2 from dba_users
  3 where rownum < 3;  

NAME

---

SYS
SYSTEM     HEADING IS TRIMMED.   NOTE that it works in SQL*Worksheet  

SQLWKS> select substr(username, 1, 15) NAME  from dba_users
 where rownum < 3;  

NAME

---

SYS
SYSTEM         And it works in Unix sqlplus.  

NAME

---

SYS
SYSTEM       Thanks for any advice.      

John Fedock
iXL, Inc.

 <mailto:jfedock_at_ixl.com> jfedock_at_ixl.com Received on Fri Jan 05 2001 - 13:07:28 CST