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拆分逗号分隔的字符串
最新推荐文章于 2022-09-14 15:01:33 发布