Yes it is possible try out this code
==========================================
begin
for x in (select usr_id from emp)
loop
update emp set salary=1000
where emp_id=x.emp_id
and salary<1000;
commit;
end loop;
end;
==========================================
--
Thanks and Regards,
Opus Software Solution(Pune)
Niraj Singh Parihar
Mobile Number : +919890492566.
On Fri, Nov 20, 2009 at 4:04 AM, cate <[email protected]> wrote:
> for item in ( sdfsdfsdfsdfsdfsdf from MYTABLE sdfsdfsdfsdfsdfsdf )
>
> loop
>
> update MYTABLE sfsdfsdfsdfsdfsdfsdf
>
>
>
> Is this legal? Can it be done?
> Thank you.
>
> --
> You received this message because you are subscribed to the Google
> Groups "Oracle PL/SQL" group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/Oracle-PLSQL?hl=en
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
