(Oracle) Data volume statistics stored procedures

This procedure applies to Oracle data volume statistics.

Create or Replace procedureSp_get_tab_count asv_tablename HDSD_TJ. Tablename%type; V_tablecount HDSD_TJ. Tablecount%type; V_tmpvarchar2( -); V_TMP2varchar2( -); V_tmp3varchar2( -); cursorCur_tab is  SelectTableName fromHDSD_TJ;begin   OpenCur_tab; LoopFetchCur_tab intoV_tablename; Exit  whenCur_tab%NotFound; V_tmp:='Analyze Table'||V_tablename||'Estimate Statistics'; Executeimmediate v_tmp; V_TMP2:= 'Select Num_rows from tabs where table_name =" "||V_tablename||" '"; ExecuteImmediate V_TMP2 intoV_tablecount; V_tmp3:='Update HDSD_TJ Set tablecount='||V_tablecount||'WHERE tableName =" "||V_tablename||" '"; Executeimmediate V_tmp3; EndLoop; CloseCur_tab;End;

-- Create Table Create Table HDSD_TJ (  tablename  VARCHAR2(+),  number (  A ))

(Oracle) Data volume statistics stored procedures