How to view the number of rows per child of a specified partition table in Oracle

Bulk gets the number of rows per child of the specified partition table!

Otherwise manual inquiry too troublesome!

---View the number of rows per child of a specified partition table

Create or replace procedure show_tabparcnt

(Partiton_tablename in User_tab_partitions.table_name%type)--Input parameters

As

TYPE cur is REF CURSOR return user_tab_partitions%rowtype; --Declaring the cursor type to ref

A cur; --Declaring a variable to be a REF CURSOR type

Re number;

Osname User_tab_partitions%rowtype;

Begin

Open a For select * from User_tab_partitions where Table_name=upper (Partiton_tablename);

Loop

Fetch a into osname;

Exit when a% NotFound;

Execute immediate ' SELECT COUNT (*) from ' | | Upper (Partiton_tablename) | | ' partition (' | | osname.partition_name| | ') '

into re;

Dbms_output.put_line (' User partition table ' | | Upper (Partiton_tablename) | | The Zoning ' | | osname.partition_name| | ' The number of rows is: ' | | re| | '; ');

End Loop;

Close A;

End

/

exec show_tabparcnt (' Orderlog ');

Back to the column page: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/