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 || ',%';
解决方案 »
- C# 操作oracle dmp文件的导入
- 存储过程返回临时表,大家帮忙看看~
- 怎样将ORACLE中的数据转入SQL SERVER,并每天更新?
- pl/sql 问题
- 很简单的select 语句 可是不知道怎么写 100分 ,
- 急,数据恢复!
- 简单问题:10分
- 请教一下,ORACLE标准版里说是5用户是一个什么样的概念?
- 安装问题:/*加载数据库时出错*Queries*/,怎么办?
- 如何将任意格式的数据(Excel,FoxPro,Access,SQL-Server......)导入Oracle?
- aix7.1 执行runcluvfy.sh报错
- 存储过程如何动态接受输入的SQL select语句然后存储过程中输出记录集
with t as
(select 'ou=O12121,ou=orgs,ou=gs,o=sgcc' dn, '12121' sgccorgid
from dual
union all
select 'ou=O12122,ou=org,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 REGEXP_SUBSTR(t.dn,'[[:digit:]]+')=t.sgccorgid
with t as
(select 'ou=O12121,ou=orgs,ou=gs,o=sgcc' dn, '12121' sgccorgid
from dual
union all
select 'ou=O12122,ou=org,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 substr(t.DN,5,5)=t.sgccorgid;