Question

oracle语句模糊查询后跟子查询的问题

select pk_site from ql_bd_site where nvl(dr,0)=0 and sitename like (select sitename from ql_bd_site where pk_site ='1001H510000000005JZC')

like后应加上% 但是不清楚怎么加 加到哪 希望大神帮我下，感谢

Answer 1

试试吧 like '%'||(select sitename from ql_bd_site where pk_site ='1001H510000000005JZC')||'%'