On Wed, Nov 26, 2008 at 6:36 PM, Ravi Chemudugunta
<[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I have the following query.
>
> select part_id, consume_part(part_id) from part where in_use = false;
>
> does it:
> a/ iterate over all parts, calling consume on them and then show the
> records where
Hi all,
I have the following query.
select part_id, consume_part(part_id) from part where in_use = false;
does it:
a/ iterate over all parts, calling consume on them and then show the
records where in_use is false (i.e. all parts have been consumed by the SP
consume_part) or
b/ filter