oracle merge

--测试用数据，在49.55上
--SELECT * FROM scott.rc_accounts
MERGE INTO scott.rc_accounts md
USING (
SELECT  fra.account_code,dept_id,fra.use_flag,rd.dept_code FROM fs_pwsc.rc_accounts fra
  JOIN rs_dept rd
  USING (dept_id)
  ) tt
ON (1=0)
WHEN  NOT MATCHED THEN
INSERT  VALUES (tt.account_code,tt.dept_id,tt.use_flag,tt.dept_code
)


--正式库50.65 先清空表，再执行下面的函数

MERGE INTO m_data.dc_department md
USING  fs_pwsc.rs_dept rd
ON (1=0)
WHEN  NOT MATCHED THEN
INSERT  VALUES (rd.dept_id,rd.dept_name,rd.upper_dept_id,rd.dept_level_flag,
rd.use_flag,rd.dept_code,''
)