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

Set serveroutput on

Declare

T_count number (10)

T_str VARCHAR2 (500)

Cursor t_tables is select table_name from user_tables

Begin

For t_row in t_tables loop

T_str: = 'select count (*) from' | | t_row.table_name

Execute immediate t_str into t_count

Dbms_output.put_line (t_row.table_name | |'='| | to_char (t_count))

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.