Oracle 裏可以這樣寫,不考慮performance阿
select a.*
from a, account b
where instr(a.accountinfo, b.accountnum) > 0