oracle_update join

    UPDATE /*+BYPASS_UJVC+*/
           (SELECT P.PROG_NO AA,
                  SUBSTR (J.JOB_CODE, 2, 3) BB,
                  P.PROG_NO, J.PROG_NO, J.JOB_CODE
             FROM TABLE P,
                  TABLE J
            WHERE P.CAR_CODE = J.CAR_CODE
                  AND P.HO_NO = J.HO_NO
                  AND P.PROG_NO = J.PROG_NO)
       SET AA =  BB;   

--/*+BYPASS_UJVC+*/ 이건 검색 해보기 ㅋ