declare
cursor t_sor is
select table_name from user_table;
num number:=0;
begin
for v_sor in t_sor loop
execute immediate 'select count(1) from '||v_sor.table_name into num;
if num=0 then
dbms_output.put_line(v_sor.table_name);
end if;
end loop;
end;
/