Re: SqlPlus headers

From: Peter van Rijn <pgm.van.rijnREMOVE_at_THIShccnet.nl>
Date: Fri, 18 Nov 2005 15:35:27 +0100
Message-ID: <11nrplggcfm405a@corp.supernews.com>

>
> SELECT TO_CHAR(COL1, 'DD-MON-YYYY HH24:MI:SS') "A LONG ALIAS THAT
> CHANGES", COL2, COL3
> FROM HEADING_TEST
>
> I have already executed the command COLUMN COL1 FORMAT A51
>
> The output from SqlPlus is:
>
> A LONG ALIAS THAT CH COL2 COL3
> 18-NOV-2005 11:47:47 21-NOV-05 17-NOV-05
>
> Again the alias is truncated. Any ideas?
>

Yes, you should use:

COLUMN "A LONG ALIAS THAT CHANGES" FORMAT A51 regards,
Peter Received on Fri Nov 18 2005 - 08:35:27 CST