Re: PL/SQL Questions.

Your UPDATE sets the value of TESTID in all tuples of the USERS table to 3 in the last run of the loop. I guess you forgot some WHERE clause.

        Mikolaj

> Can anyone tell me why the following code doesn't produce the desire
> results?
>
>
> BEGIN
> FOR x IN 1..3 LOOP
> update users set testid = x;
> DBMS_OUTPUT.PUT_LINE(x);
> END LOOP;
> END;
>
> output to sqlplus is : 1
> 2
> 3
>
> output in testid is : 3
> 3
> 3
>
>
>
> RH 6.1
> Oracle 8.1.6
>
> Tony
Received on Mon Jul 30 2001 - 05:06:20 CDT