orale数据库怎么查询a表theme字段里包含b表id字段的信息

Question

我要查询a表里所有theme字段里包含b表id字段信息的行，有没有什么功能可以快速查询

Answer 1

SQL> select * from t1;

        ID NAME
---------- -----
         1 safa
         2 ketss
         3 cigos
         4 bfird

SQL> select * from t2;

        ID NAME
---------- -----
         1 o
         2 b
         3 c
         4 d
         5 k

SQL> select id,name from t1 where exists (select 1 name from t2 where t1.name like '%' || t2.name || '%');

        ID NAME
---------- -----
         2 ketss
         3 cigos
         4 bfird