create table TEST_USER.TABLE_1 as select 'TABLE_1' name, rownum id, sysdate dt from dual connect by rownum <= 5;
create table TEST_USER.TABLE_2 as select 'TABLE_2' name, rownum id, sysdate dt from dual connect by rownum <= 10;


with table_list as ( select 'TEST_USER' owner, 'TABLE_1' table_name from dual union all
                     select 'TEST_USER' owner, 'TABLE_2' table_name from dual union all
                     select 'TEST_USER' owner, 'TABLE_3' table_name from dual )
  select extract( val, '/ROW/NAME/text()' ).GetStringVal() NAME,
         extract( val, '/ROW/ID/text()' ).GetNumberVal() ID,
         extract( val, '/ROW/DT/text()' ).GetStringVal() DT
    from ( select x.column_value val
             from dba_tables t,
                  table_list l,
                  table ( xmlsequence( dbms_xmlgen.getxmltype( 'select name, id, to_char(dt,''dd.mm.yyyy hh24:mi:ss'') dt from ' || t.owner || '.' || t.table_name ).extract( 'ROWSET/*' ) ) ) x
               where t.owner = l.owner
                 and t.table_name = l.table_name );