set serveroutput on/

begin
  declare stmt varchar(4000);
  declare idx int default 0;
  declare tabname varchar(128);

  for c as 
    select str_date 
    from table (values 
      'select * from syscat.tables'
    , 'select * from syscat.columns'
    ) t(str_date)
  do 
    set idx = idx + 1;
    set tabname = 'session.tab' || rtrim(char(idx));
    set stmt = 
      'declare global temporary table ' || tabname
    ||' as (' || c.str_date || ') definition only with replace on commit preserve rows not logged';
    execute immediate stmt;
    set stmt = 'insert into ' || tabname || ' ' || c.str_date;
    execute immediate stmt;
    call dbms_output.put_line('stmt: ' || c.str_date);
    call dbms_output.put_line('tab : ' || tabname);
  end for;
end/

select count(1) from session.tab1/

select count(1) from session.tab2/