Запрос на выборку

WITH t AS (SELECT 'TAB$, IND$, ICOL$' x FROM dual)
select table_name from all_tables where table_name in (
       SELECT trim( substr(x, 1+lag(pos,1,0) OVER(ORDER BY pos),pos-lag(pos,1,0) OVER(ORDER BY pos)-1) ) numbers 
       FROM (SELECT x, instr(x||',',',',1,LEVEL) pos 
             FROM t
       CONNECT BY instr(x||',',',',1,LEVEL)>0))

select table_name
from all_tables
where replace(','||'name1, name2,..., name n'||',',' ','') like '%,'||table_name||',%'