Shulou(Shulou.com)06/01 Report--

DECLARE CURSOR C1 is select table_name from user_tables; V_TABLE_NAME user_tables.TABLE_NAME%TYPE; V_CNT number; V_SQL varchar2 (2000); BEGIN FOR V_TABLE_NAME in C1 loop V_SQL: = 'select count (1) from' | | execute immediate V_SQL into TABLENAME.tableSecretameNAME.TableCNT; dbms_output.put_line (V_TABLE_NAME.table_name | |','| V_CNT); end loop;end

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.