Oracle stored procedures that count the number of records in all tables under Oracle's current user

Create or Replace procedure Tj_data  
  is--variable v_tablename VARCHAR2 for the current stored procedure
  ;
  V_sql   varchar2 ();
  V_count integer;
  --Gets all the tables in the current database
  CURSOR Table_loop is SELECT table_name from user_tables;

  BEGIN
    --Opens the cursor open
    table_loop;
      LOOP
        FETCH table_loop into V_tablename;
          EXIT when Table_loop%notfound;
               V_sql:= ' Select COUNT (1) from ' | | V_tablename;
               Execute immediate v_sql into V_count;
               Dbms_output.put_line (v_tablename| | | V_count);
      End LOOP;
     Close Table_loop;
End Tj_data;

Run the stored procedure using Pl/sql, and you can see the statistical results under the DBMS Output window. (The value of the buffer size appropriate to a little bit)