Re: Unexpected behavior in inline view with a function call

Paul,

Thanks for the explanation. I think our developer figured out a workaround, but it's much appreciated.

Anne

Paul wrote:

> The inline view is called once for every row in the outer query, so if your
> function increments a number by one and you main query returns 5 rows the
> total number of increments would be 5.
>
> Not sure how to solve the problem posed however, try posting the problem to
> the Quest PL/SQL Pipeline if you get no joy here.
>
> Paul
Received on Mon Sep 16 2002 - 10:51:47 CDT