update temp1 a
set (a.fullname) = (select first_name
from temp2 b
where a.account = b.emp_num
and rownum = 1)
where exists
(select 1 from temp2 b where b.EMP_NUM = a.ACCOUNT);
set (a.fullname) = (select first_name
from temp2 b
where a.account = b.emp_num
and rownum = 1)
where exists
(select 1 from temp2 b where b.EMP_NUM = a.ACCOUNT);