DECLARE
vtname VARCHAR2(100);
CURSOR cur_tablename IS
SELECT tname
FROM tab;
BEGIN
OPEN cur_tablename;

FOR i IN 1 .. 100
LOOP
FETCH cur_tablename
INTO vtname;
EXIT WHEN cur_tablename NOTFOUND;
dbms_output.put_line(' table name' || vtname);
BEGIN
EXECUTE IMMEDIATE ' select 1 from ' || vtname; --||' where rownum<2';
EXCEPTION
WHEN no_data_found THEN

dbms_output.put_line(' doesn''t have data' || vtname);
END;
END LOOP;

CLOSE cur_tablename;

END;