Re: Q: Column Format ?

>
> Hi!
>
> We are using Ora-Perl scripts to display data from our Oracle database.
> We are having problems with longer 'column aliases' in queries where the
> alias name exceeds the column size. SQL*Plus truncates the extra characters.
> I can't use the 'column XXX heading YYYYY' setting and 'cloumn format aXX'
> also does not work. My query looks like this:
>
> 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)
>

Could you clarify this? You state that you are using Oraperl, but the example you give is not Perl code.

SQL*PLUS statements such as 'column' don't have any effect in Perl.

Jared
jared_at_valleynet.com Received on Wed Jan 10 1996 - 15:48:09 CST