字母顺序不同,元素相同,如何来写呢?
答:
从表中查出来,重新排序,再比较:
and (select to_char(wm_concat(STA.CODE))
from Sys_t_Station sta
where ',' || p.WORKSTACODE || ',' LIKE '%,' || STA.CODE || ',%') =
(select to_char(wm_concat(STA.CODE))
from Sys_t_Station sta
where ',ZPB-ZTN,ZTN,ZTN-ZHB,' LIKE '%,' || STA.CODE || ',%')