Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- )
Advertisement
