[Oracle] JOIN UPDATE

SAMPLE

UPDATE /*+ BYPASS_UJVC */
(
  SELECT A.COLNM RA
             , B.COLNM RB 
     FROM A, B
   WHERE A.KEY= B.KEY
) SET RA = RB;

 

 

CASE 1

UPDATE  /*+ BYPASS_UJVC */
( 
  SELECT  B.BIZREGNO,  B.POINT,  A.MPOINT 
     FROM  ISS_CUST_REM_POINT B
             ,  ( SELECT  BIZREGNO  ,SUM(POINT) AS MPOINT
                      FROM  ISS_POINT_USE_DET
                    WHERE  USE_TP_CD = 'E01'
                        AND  TRAD_DE IN ('20110303','20110317')
                        AND REG_ID = 'admin11'
                    GROUP  BY  BIZREGNO
                )  A 
   WHERE  B.BIZREGNO=A.BIZREGNO
)
SET    POINT = POINT+MPOINT; 



CASE 2

  UPDATE  /*+ BYPASS_UJVC */                    
  (                                            
  SELECT  A.IBKAMT,  A.BADATE,  A.YONGCD,  B.IMONEY 
     FROM  MULCAL A,                             
            (  SELECT  Y.BADATE,  Y.YONGCD,  Y.IMONEY 
                   FROM  MULIBK X                     
                     JOIN  MULIBL Y                     
                       ON  Y.IBKNUM  =  X.IBKNUM          
                 WHERE  X.IBKNUM  =  '201105250001'            
            ) B                                   
   WHERE  A.BADATE  =  B.BADATE                   
       AND  A.YONGCD  =  B.YONGCD                   
  )                                            
  SET  IBKAMT  =  IBKAMT  -  IMONEY