SQL不支持表名使用变量/etc-支持您要求的唯一方法是使用动态SQL:

SQL does not support a variable/etc for the table name -- the only means of supporting what you ask is by using dynamic SQL:

FOR i IN (SELECT tab_name
            FROM META m
           WHERE m.type = ?) LOOP
  EXECUTE IMMEDIATE 'SELECT * FROM '|| i.tab_name ||'';
END LOOP;