select regexp_substr((select visavis from empassess where id = 151),
'[^,]+',
1,
level)
from dual
connect by regexp_substr((select visavis
from empassess
where id = 151),
'[^,]+',
1,
level) is not null)
order by id
select count(id)
from hrmresource
where id in
(select regexp_substr((select visavis from empassess where id = 151),
'[^,]+',
1,
level)
from dual
connect by regexp_substr((select visavis
from empassess
where id = 151),
'[^,]+',
1,
level) is not null)
但是这个只有29条,
前提说明一下,这个hrmresource 表中存在这个31个的ID
所以求助这个是什么原因导致