일괄 insert, update

UPDATE qis_install_fail A1

SET ( accept_no, center_cd ) = (
 SELECT TA.accept_no, TA.plnt
 FROM (
...
 ) TA
 WHERE A1.delivery_no = TA.delivery_no
)


INSERT INTO qis_if_main_stat
 (........)
SELECT
....