SELECT DISTINCT a.DEVICE_SYS_NBR, b.DIRECTION_TYPE
FROM T_DEVICE_SYS a, T_SYS_SECTION b
WHERE INSTR(a.SECTION_ID_LIST || ',',b.SECTION_ID || ',') > 0
AND a.DEVICE_TYPE = '01'
AND a.USE_STATUS_FLAG = '1'
oracle拆分逗号分隔的字符串
最新推荐文章于 2024-08-21 15:59:59 发布