BEGIN
  FOR c IN ( select owner as schema_name, table_name from sys.all_tables where table_name like '--PREFIX--' )
  LOOP
    EXECUTE IMMEDIATE ' SELECT * FROM ' || c.table_name;
  END LOOP;
END;