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
)
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
)
Comments
0 B
|👍
/👎
0 B
|👍
/👎