Breaking News: Grepper is joining You.com. Read the official announcement!

plsql merge with

R Dyk answered on March 19, 2023 Popularity 5/10 Helpfulness 2/10

answer plsql merge with

related plsql merge

plsql merge with

Comment

MERGE INTO mt_tranchetext mergeTable
USING
(WITH drivingTable AS (SELECT udtranche, udfo FROM fis.ft_tranche) 
SELECT drivingTable.udfo, drivingTable.udtranche FROM drivingTable 
WHERE drivingTable.udfo NOT IN (SELECT udfo FROM mt_tranchetext  WHERE mt_tranchetext.udtext='PERF_MESSUNG_START') ) drivingTable
ON (mergeTable.udtranche = drivingTable.udtranche 
    AND mergeTable.udtext='PERF_MESSUNG_START'  
    AND mergeTable.dtupdate > to_date('20170112', 'yyyymmdd)') 
   )
WHEN MATCHED THEN 
 UPDATE SET mergeTable.udfo = drivingTable.udfo

Popularity 5/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Mar 19 2023

R Dyk

0 Answers Avg Quality 2/10

Closely Related Answers

plsql merge

Comment

MERGE INTO mt_tranchetext mergeTable
USING
(SELECT udtranche, udfo FROM fis.ft_tranche) drivingTable
ON (mergeTable.udtranche = drivingTable.udtranche AND 
       mergeTable.udtext='PERF_MESSUNG_START' AND 
       mergeTable.dtupdate > to_date('20170112', 'yyyymmdd)'))
WHEN MATCHED THEN 
  UPDATE SET mergeTable.udfo = drivingTable.u

Popularity 5/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Mar 19 2023

R Dyk

0 Answers Avg Quality 2/10

plsql merge with

Contents

More Related Answers

plsql merge with

Closely Related Answers

plsql merge

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.