Re: Format of output in Sql*plus

From: gazzag <gareth_at_jamms.org>
Date: 20 Apr 2006 05:53:46 -0700
Message-ID: <1145537626.359017.53230@t31g2000cwb.googlegroups.com>

patrick wrote:
> Hello everybody,
>
> I have a problem with the output of my query in Sql*Plus. Hopin for an
> answer...
>
> My output looks like:
>
> ID_XXXX SUM(XXXXXXXXXXXXXX)
> ------- --------------------
> V I 0 4
> V K 0 1
> V L 0 488
>
> The problem is it doesn't show all of ID_XXXX, which should be like
> VI030, VK019 and VL004.
> Why does it place spaces and not showing all of it?
>

Try typing the following into SQL*Plus and re-run the query:

column id_xxxx format a10

HTH -g Received on Thu Apr 20 2006 - 07:53:46 CDT