bill_lam wrote:

> Adam wrote:
>
> create procedure copythis
> as
> begin
> for
> select q, y
> from b
> into :q, :y
> do
> begin
> update a set p = :q where x = :y;
> end
> end
>
>
> if there are 100 rows selected by query inside for .... do,
> will the statement " update a set p = :q where x = :y; " be
> iterated for 100 times or executed only once?
>
> regards,
> bill

100 update statements will be executed, but with decent indexing it is
normally quick.

Set