本帖最后由 xhhjj 于 2015-4-18 11:07 编辑
只做了匹配一位的,匹配多位的得把所有集合列出来,11gr2可以使用递归with语句构造,
请参考版主的帖子
求所有子集合及其补集:40楼
http://www.itpub.net/thread-1289332-4-2.html
with a as (
select level lv,substr('ABCDEFB',level,1) atoken
from dual
connect by level <= length('ABCDEFB')
),
b as (
select level lv,substr('BERZ',level,1) btoken
from dual
connect by level <= length('BERZ')
)
select row_number() over(order by a.lv) rn,a.lv,a.atoken
from a,b
where a.atoken = b.btoken
order by a.lv
|