Oracle 数据库--一个用户同步的sql

用户同步的sql：

insert into crm_customer_user
select null,1505,username,'9ZZY9rJx8+6ITe5AWVe+dg==',null,null,name,1,101,0,-1,id,0
from sys_user where username not in (select user_name from crm_customer_user);

-- select count(1) from sys_user where username not in (select user_name from crm_customer_user);

UPDATE crm_customer_user
SET crm_customer_user.EUSERID=
  (select id from 
    (SELECT login_name, id
    FROM euser@LINK_CFD1
    WHERE login_name IN
      (SELECT username FROM sys_user) and login_name not in ('lid','wuj')-- 这两个用户名在原表中是重复的
    )eu
    where crm_customer_user.user_name=eu.login_name
  )
WHERE crm_customer_user.EUSERID=-1;

 这种：

UPDATE  ATT_VEHICLEDISPATCH AV SET AV.MAX_GROSS=
  (
    SELECT EU.WEIGHTLIMIT FROM 
    (
      SELECT 
        TC.carsign,
        CAR.WEIGHTLIMIT
      FROM T_CARDINFO TC
      JOIN CAR_WEIGHTLIMIT CAR ON TC.AXLETYPE=car.AXLETYPE
      WHERE 1       =1
      AND cardstatus=1
      AND CARDTYPE  =1
    )EU
    WHERE AV.CARNO=EU.carsign
  )
WHERE AV.max_gross is null and AV.handletime>to_date('2017-04-25 11:00','yyyy-mm-dd hh24:mi');

 

转载于:https://www.cnblogs.com/clovem/p/6117786.html