Oracle-Statistics database table total number of data

Create or Replace procedurePrc_table_count (P_flag outvarchar2) asTCOUNT Number; Scount Number; CountsqlVARCHAR2( -);BEGINTCOUNT:= 0; Scount:= 0;  forC_rowinch (      Selecttable_name fromSYS. User_tab_comments TWHERET.table_name like 'zzjg%') LOOP Countsql:='Select COUNT (1) from'||C_row.table_name;   Dbms_output.put_line (Countsql); ExecuteImmediate Countsql intoTCOUNT; Scount:=Scount+TCOUNT; ENDLOOP;  Dbms_output.put_line (Scount); P_flag:= '1';ENDPrc_table_count;

Oracle-Statistics database table total number of data