Re: PL/SQL question.

Hi!
I think you must give the query column MAX(waf_end) an alias name.

E.g:

     CURSOR C1 IS
     SELECT devwafid, devx, devy,
     MAX(waf_end) the_max_value <---------
     from VC6203D9

Frank

> CURSOR C1 IS
> SELECT devwafid, devx, devy,
> MAX(waf_end) <-------
> from VC6203D9
> where lseq in lotseq and devwafid is not NULL
> group by devwafid, devx, devy;
Received on Sun Jun 17 2001 - 09:21:15 CDT