RE: substr to trim headings

From: Glasrot, Nechama <nglasrot_at_edata.com>
Date: Fri, 5 Jan 2001 14:49:37 -0500
Message-Id: <10732.125882@fatcity.com>

SUBSTR only strips out the values ... if you want the column to be smaller you need to

COLUMN name FORMAT A12

HTH thank you ...
nechama glasrot
561-981-0635
nglasrot_at_edata.com

-----Original Message-----
From: jfedock_at_ixl.com [mailto:jfedock_at_ixl.com] Sent: Friday, January 05, 2001 2:13 PM
To: Multiple recipients of list ORACLE-L Subject: substr to trim headings

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 http://www.ixl.com <http://www.ixl.com/>  

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: jfedock_at_ixl.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Fri Jan 05 2001 - 13:49:37 CST