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
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 in_use is
