Re: SQL*Plus column format not working
From: Oliver Riesen <oliver_at_riesen-online.de>
Date: Fri, 27 Apr 2001 14:12:26 +0100
Message-ID: <9cbo39$msn$1_at_news.oberberg-online.de>
Date: Fri, 27 Apr 2001 14:12:26 +0100
Message-ID: <9cbo39$msn$1_at_news.oberberg-online.de>
The column width not only depends on the format clause but also on the length of the column title
try: col field_1 format 99 heading 'No'
Oliver Riesen
"Calvin Crumrine" <Calvin_Crumrine_at_dced.state.ak.us> schrieb im Newsbeitrag
news:3AE8AAB5.B7401698_at_dced.state.ak.us...
> OK-I've obviously forgotten something, can somebody remind me what it
> is? I have a field (Field_1) defined as Number(2). I want the column to
> be only 2 or 3 characters wide.
>
> COL Field_1 FORMAT 99
> SELECT Field_1 FROM Table_1;
> 11
> 22
> 33
>
> What's wrong? Thanks.
>
Received on Fri Apr 27 2001 - 15:12:26 CEST