3,490
社区成员
发帖
与我相关
我的任务
分享
select * from book t1
inner join tpi t2
on t2.tpino like '%' || t1.bookno || '%'
or t1.bookno like '%' || t2.tpino || '%'
select id, regexp_substr(bookno, '[^ ]+', 1, level) from Book
connect by level < length(regexp_replace(bookno, '[^ ]+')) + 1
select *
from Book a,tpi b
where a.bookno like '%'||b.tpino||'%'