Re: Format of output in Sql*plus

> select id_XXXX, sum(aantal_YYYY)
> from ZZZ.ZZZZ
> group by id_XXXX

I just had to make sure that you weren't doing anything with the ID_XXXX column in your query.

Try the following (as suggested by gazzag) in SQL*Plus:

COLUMN id_xxxx FORMAT a10
SELECT id_XXXX, SUM(aantal_YYYY)
FROM ZZZ.ZZZZ
GROUP BY id_XXXX;

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown