Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Updating multiple rows using join condition

787128Jul 23 2010 — edited Jul 26 2010

update agt_name
set agt_name.emp_num = (select nexros.emp_num
from nexros , agt_name
where nexros.userid = agt_name.retention_id)

i m getting the error

ORA-01427: single-row subquery returns more than one row

Please help me out!!

Thanks,
reacha

This post has been answered by sb92075 on Jul 23 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 23 2010

Added on Jul 23 2010

#general-database-discussions

16 comments

6,837 views