JUST DO IT ~

update temp_Test_pm_order t
       set ( t.stkname_  , t.STKTP_ ,  t.HIGHPRICE_ ,  t.LOWPRICE_ ,  t.PRICEUNIT_  ,  t.CURRENCY_CODE_ 
          ,  t.ISSTOP_ ,t.DEALUNITNAME_ ,t.MARTUNIT_ ,  t.UPDEALNUM_ , t.LOWDEALNUM_ , t.BUY_UNIT_ ,t.SALE_UNIT_
           , t.IV_UNIT_  )
  = (select stkname_  ,d.STKTP_ ,d.HIGHPRICE_ , d.LOWPRICE_ ,d.PRICEUNIT_ , d.CURRENCY_CODE_ 
          , d.ISSTOP_, d.DEALUNITNAME_  , d.MARTUNIT_  , d.UPDEALNUM_ ,d.LOWDEALNUM_ , d.BUY_UNIT_ ,d.SALE_UNIT_
          , d.IV_UNIT_ 
      from dl_stkcode d 
      where d.exchgcode_ = t.exchgcode_ and d.stkcode_ = t.stkcode_)

UPDATE STATEMENT, GOAL = CHOOSE       
 UPDATE Object owner=IDMP Object name=TEMP_TEST_PM_ORDER     
  TABLE ACCESS FULL Object owner=IDMP Object name=TEMP_TEST_PM_ORDER     
  TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE     
   INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE     

update temp_Test_pm_order t
       set 
           t.STKTP_         = (select d.STKTP_
                                 from dl_stkcode d
                                where d.exchgcode_ = t.exchgcode_
                                  and d.stkcode_ = t.stkcode_),
           t.HIGHPRICE_     = (select d.HIGHPRICE_
                                 from dl_stkcode d
                                where d.exchgcode_ = t.exchgcode_
                                  and d.stkcode_ = t.stkcode_),
           t.LOWPRICE_      = (select d.LOWPRICE_
                                 from dl_stkcode d
                                where d.exchgcode_ = t.exchgcode_
                                  and d.stkcode_ = t.stkcode_),
           t.PRICEUNIT_     = (select d.PRICEUNIT_
                                 from dl_stkcode d
                                where d.exchgcode_ = t.exchgcode_
                                  and d.stkcode_ = t.stkcode_),
           t.CURRENCY_CODE_ = (select d.CURRENCY_CODE_
                                 from dl_stkcode d
                                where d.exchgcode_ = t.exchgcode_
                                  and d.stkcode_ = t.stkcode_),
           t.ISSTOP_        = (select d.ISSTOP_
                                 from dl_stkcode d
                                where d.exchgcode_ = t.exchgcode_
                                  and d.stkcode_ = t.stkcode_),
           t.DEALUNITNAME_  = (select d.DEALUNITNAME_
                                 from dl_stkcode d
                                where d.exchgcode_ = t.exchgcode_
                                  and d.stkcode_ = t.stkcode_),
           t.MARTUNIT_      = (select d.MARTUNIT_
                                 from dl_stkcode d
                                where d.exchgcode_ = t.exchgcode_
                                  and d.stkcode_ = t.stkcode_),
           t.UPDEALNUM_     = (select d.UPDEALNUM_
                                 from dl_stkcode d
                                where d.exchgcode_ = t.exchgcode_
                                  and d.stkcode_ = t.stkcode_),
           t.LOWDEALNUM_    = (select d.LOWDEALNUM_
                                 from dl_stkcode d
                                where d.exchgcode_ = t.exchgcode_
                                  and d.stkcode_ = t.stkcode_),
           t.BUY_UNIT_      = (select d.BUY_UNIT_
                                 from dl_stkcode d
                                where d.exchgcode_ = t.exchgcode_
                                  and d.stkcode_ = t.stkcode_),
           t.SALE_UNIT_     = (select d.SALE_UNIT_
                                 from dl_stkcode d
                                where d.exchgcode_ = t.exchgcode_
                                  and d.stkcode_ = t.stkcode_),
           t.IV_UNIT_       = (select d.IV_UNIT_
                                 from dl_stkcode d
                                where d.exchgcode_ = t.exchgcode_
                                  and d.stkcode_ = t.stkcode_) 

UPDATE STATEMENT, GOAL = CHOOSE       
 UPDATE Object owner=IDMP Object name=TEMP_TEST_PM_ORDER     
  TABLE ACCESS FULL Object owner=IDMP Object name=TEMP_TEST_PM_ORDER     
  TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE     
   INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE     
  TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE     
   INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE     
  TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE     
   INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE     
  TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE     
   INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE     
  TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE     
   INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE     
  TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE     
   INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE     
  TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE     
   INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE     
  TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE     
   INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE     
  TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE     
   INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE     
  TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE     
   INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE     
  TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE     
   INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE     
  TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE     
   INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE     
  TABLE ACCESS BY INDEX ROWID Object owner=IDMP Object name=DL_STKCODE     
   INDEX UNIQUE SCAN Object owner=IDMP Object name=PK_DL_STKCODE