Can someone explain what this piece of code means....<BR><BR> select decode(count(*), 0, 'N', 'Y') into retVal .......<BR><BR><BR>Any help would be appreciated.<BR>Thanks.
what db are you using?<BR>
if count(*) is zero the result of the decode function is 'N' otherwise it will be 'Y'<BR><BR>
At a guess, I'd say that if count(*) is 0, the decode function will return "N", if not, it will return "Y".<BR><BR>It might be the other way round though.
You back huh<BR><BR><BR>have not seen you on here in a long time<BR><BR>