Select in update

Hello!

I need to update a table (13000 rows) using something
like this:
update rua set cod_bairro =
(select cod_bairro from bairro b where b.vetbairro =
r.vetbairro)

Is it possible?? Can I use a select statement as input
for an update??

Thanks,
JP

__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com