오리클 select update

update test t
set t.title = (
select p.title
from pms p
where p.id = t.id
)
where r.title is null
and exists (
select p.title
from pms p
where p.id = r.id
)