MERGE INTO GHMT_SCORE GH
    USING WEDB_REPOSITORY WR
    ON(
        WR.GSD_NO = GH.GSD_NO
        AND WR.SID_NO = GH.SID_NO
    )
    WHEN MATCHED THEN
    UPDATE  SET GH.CREATE_DATE = WR.CREATE_DATE
    WHERE GH.GSD_NO > 0
    AND GH.GH_ID = 60
    AND WR.SID_NO = 1
    AND WR.CREATE_DATE IS NOT NULL
    AND GH.PSRD = 'N'

orclz>
orclz> merge into emp using dept on(emp.deptno=dept.deptno)
  2   when matched then update set ename=dname;

14 rows merged.

orclz> rollback;

Rollback complete.

orclz> update emp set ename=(select dname from dept where dept.deptno=emp.deptno);

14 rows updated.

orclz> rollback;

Rollback complete.

orclz>