title: Get counts of all tables in a schema
body: <p>I am trying to get the record counts of all tables in a schema. I am having trouble writing the PL/SQL. Here is what I have done so far, but I am getting errors. Please suggest any changes:</p>
  
  <pre><code>DECLARE
  v_owner varchar2(40);
  v_table_name varchar2(40);
  
  cursor get_tables is
  select distinct table_name,user
  from user_tables
  where lower(user) = 'SCHEMA_NAME';
  
  
  begin
  
  open get_tables;
  fetch get_tables into v_table_name,v_owner;
  
      INSERT INTO STATS_TABLE(TABLE_NAME,SCHEMA_NAME,RECORD_COUNT,CREATED)
      SELECT v_table_name,v_owner,COUNT(*),TO_DATE(SYSDATE,'DD-MON-YY') FROM         v_table_name;
  
  CLOSE get_tables;
  
  END;
  </code></pre>