update scirpt got ora-01427 when try to update from another table

[uchaganti]

Try distinct inside the sub query

update application_xml_q2007 a
set a.xml_name = (select DISTINCT b.xml_name from application_xml_info_add b where a.form_id = b.form_id);