select distinct id from names where tid = 'AREACODE' And dsc like '%' || v_areacode其中dsc like '%' || v_areacode

问题描述:

select distinct id from names where tid = 'AREACODE' And dsc like '%' || v_areacode
其中dsc like '%' || v_areacode