Re: Clarification to Q:Column Format ?

> select
> nvl( PROJECT.SW_APPR, 'NO ANSWER') "Development Approach",
> count (distinct PROJECT.PROJ_NO) "# of projects"
> from
> PROJECT
> group by
> PROJECT.SW_APPR;
>
> The display shows:
>
> Development Appr # of projects
> ---------------- -------------
> WATERFALL 55
> EVOLUTIONARY 54
>
> If I do 'column SW_APPR format a30':
>
> It works If I do not use nvl in my query. But I have to use nvl in my queries.
> I can't set the Heading because of some other constraints in my scripts. We
 are
> using Oracle 7.0.16 on SUN OS 4.1.3.
>
> Any ideas or work arounds are appreciated. Thanks in adavnce.
>
> Regards,
> Prasad
> (pbammidi_at_cs.utep.edu)
>

try this:

col swappr format a30 heading 'Development Approach'

select
nvl( PROJECT.SW_APPR, 'NO ANSWER') swappr, count (distinct PROJECT.PROJ_NO) "# of projects" from
PROJECT
group by
PROJECT.SW_APPR; Jared
jared_at_valleynet.com Received on Thu Jan 11 1996 - 10:34:01 CST