create or replace procedure SP_GET_TAB_COUNT

 as

   v_tableName HDSD_TJ.Tablename%type;

   v_tableCount  HDSD_TJ.Tablecount%type;

   v_tmp varchar2(500);

   v_tmp2 varchar2(500);

   v_tmp3 varchar2(500);

   cursor cur_tab is  select tableName from HDSD_TJ;

 begin

   open  cur_tab;

   loop

     fetch cur_tab into  v_tableName;

     exit when  cur_tab%notfound;

        v_tmp:='analyze table  '||v_tableName||'  estimate statistics';

        execute immediate v_tmp;

        v_tmp2:= 'select num_rows  from tabs where table_name ='''||v_tableName||'''';

        execute immediate v_tmp2 into  v_tableCount;

        v_tmp3:='update HDSD_TJ set Tablecount='||v_tableCount||' where tableName ='''||v_tableName||'''';

        execute immediate v_tmp3;

   end loop;

   close  cur_tab;

 end;

-- Create table

create table HDSD_TJ

(

  tablename  VARCHAR2(100),

  tablecount NUMBER(12)

)