摘要： oracle：select count(*) from t1,t2 where t1.col1 like '%'||t2.col||'%';(任意位置匹配)同理可有只匹配前或后的select count(*) from t1,t2 where t1.col1 like t2.col||'%';select count(*) from t1,t2 where t1.col1 like '%'||t2.col; 阅读全文