oracle数据库
如图 提取 dn 下 ou=O.....与 sgccOrgId对应的数据对比 看有没有差异并把不一样的 查询出来
------解决方案--------------------
with t as
(select 'ou=O12121,ou=orgs,ou=gs,o=sgcc' dn, '12121' sgccorgid
from dual
union all
select 'ou=O12122,ou=orgs,ou=gs,o=sgcc' dn, '12122' sgccorgid
from dual
union all
select 'ou=O12123,ou=orgs,ou=gs,o=sgcc' dn, '12125' sgccorgid
from dual
union all
select 'ou=O12124,ou=orgs,ou=gs,o=sgcc' dn, '12124' sgccorgid
from dual
union all
select 'ou=O12125,ou=orgs,ou=gs,o=sgcc' dn, '12126' sgccorgid
from dual)
select * from t where t.dn not like 'ou=O'
------解决方案--------------------
t.sgccorgid
------解决方案--------------------
',%';