select * from dtree where parentid = 999999 and dataid in (
        select to_number(regexp_substr('1111,2222,3333' , '[^,]+',1,level)) from dual
        connect by to_number(regexp_substr('1111,2222,3333' ,'[^,]+',1,level)) is not null
)