学步园

declare
  v_Name    varchar2(30) := 'T_IISS_SUBSCRIBE';
  v_NewName varchar2(50);
  v_cnt     number;
  cursor mycursor is
    select t.gid from t_Iiss_Location t;

begin
  for T in mycursor loop
    v_NewName := (v_Name || T.gid);
    select count(*)
      into v_cnt
      from user_tables
     where table_name = v_NewName;
 
    if v_cnt <= 0 then
      dbms_output.put_line(v_NewName);
    end If;
  end loop;
end;

说明：查询以"T_IISS_SUBSCRIBE"+T_IISS_Location.GID规则命名的表是否都存在。输出不存在的表名。