| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Format of output in Sql*plus
Brian Peasland wrote:
>
> 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
>
You may also want to type the following at a SQL*Plus prompt:
help column
HTH -g Received on Thu Apr 20 2006 - 08:37:31 CDT
 |
 |