oracle中字符串分割, id name 1 aa,bb,cc, ......... 查找name中包含aa的行 select t.groupid,t.userid from (select groupid,substr(',' || first_users || ',' ,instr(',' || first_users || ',', ',', 1, rn) + 1 ,instr(',' || first_users || ',', ',', 1, rn + 1) - instr(',' || first_users || ',', ',', 1, rn) - 1) as name from webmon_client_profile ,(select rownum rn from all_objects where rownum <= 10) where instr(first_users, ',', 1, rn) > 0 order by groupid) t where t.userid='aa'