select id, regexp_substr(bookno, '[^ ]+', 1, level) from Book
connect by level < length(regexp_replace(bookno, '[^ ]+')) + 1
------解决方案--------------------
请参考:
SQL code
select * from book t1
inner join tpi t2
on t2.tpino like '%' || t1.bookno || '%'
or t1.bookno like '%' || t2.tpino || '%'
------解决方案--------------------