Multi row update

update STB_STORE@SCKWEB A SET A.STORE_BIZ_CD = (

    SELECT B.BRANCH_CODE FROM MSR_BRANCH_INFO B

    WHERE B.BRANCH_NAME = REPLACE(A.STORE_NM, '점', '')

    )

WHERE REPLACE(A.STORE_NM, '점', '') IN (SELECT BRANCH_NAME FROM MSR_BRANCH_INFO);