title: query to find number of empty tables in my schema name HR
body: <p>I want to find the number of empty tables in my schema hr and i have written a code for it:</p>
  
  <pre><code>set serveroutput on;
  
  
  Declare
  d Number;
  c varchar2(25);
  cursor c1 is SELECT DISTINCT OWNER, OBJECT_NAME FROM DBA_OBJECTS WHERE OBJECT_TYPE = 'TABLE' AND OWNER = 'HR';
  
  Begin
   for r in c1
  Loop
  select count(*) into d
  from (r.object_name);
  if (d = 0) then
  dbms_output.put_line(r.object_name||'is Empty');
  end if;
  end loop;
  end;
  </code></pre>
  
  <p>but its throwing error at this line from (r.object_name). can anyone help me in this?</p>