oracle中两列相似匹配
SELECT T1.ORGAN_ID
FROM RY_XXB_2017_ T1,
ORG_UNIFIED_ID_1 T2
WHERE T1.Organ_Name LIKE CONCAT(’%’, CONCAT(T2.ORG_NAME, ‘%’)
oracle 相似匹配
最新推荐文章于 2022-11-09 18:48:15 发布
oracle中两列相似匹配
SELECT T1.ORGAN_ID
FROM RY_XXB_2017_ T1,
ORG_UNIFIED_ID_1 T2
WHERE T1.Organ_Name LIKE CONCAT(’%’, CONCAT(T2.ORG_NAME, ‘%’)