declare
cnt number;
sqlstr='XXXXXXXXXXXXXXXXXXXXXXXXXXX';
cursor c is
select distinct table_name from all_tables;
begin
for my_c in c loop
if(instr(sqlstr,my_c.table_name)>0) then
dbms_output.put_line(my_c.table_name);
end if;
end loop;
end;
/
以上只适合oracle
SHOW TABLES;
寻找form 或 join后面的名字,一个一个的查。