with t1 as(select 'd3ab9kr123' c from dual)
,t2 as (select 'd3aoweajf' c from dual)
select substr(t1.c,1,max(level))
from t1,t2
where instr('$!'||t1.c,'$!'||substr(t2.c,1,level))>0
connect by level<=length(t2.c)
,t2 as (select 'd3aoweajf' c from dual)
select substr(t1.c,1,max(level))
from t1,t2
where instr('$!'||t1.c,'$!'||substr(t2.c,1,level))>0
connect by level<=length(t2.c)
select max(rk) rk
from
(
select wm_concat(rk) over (order by rk) rk from pj where pjid=80 and rk>0
)
1.我把t1和t2换成sql语句,就报“不是单分组函数”
2.如果在最后加上group by t1.rk,但结果只是t1.rk的值,并不是想要的结果
改了一会才发现,好像和另一个帖的要求是一样的