table row count report for all tables
Hi
Many of you probably know this option Laurent option (with the PL/SQL function) ref- https://laurentschneider.com/wordpress/2007/04/how-do-i-store-the-counts-of-all-tables.html
create or replace function count_rows(table_name varchar2)
return varchar2 is
i number;
r sys_refcursor;
begin
open r for 'select count(*) c from '||table_name;
fetch r into i;
return i;
end;
/
select table_name,count_rows(table_name) from user_tables;
But actually i was looking some options without the function because i want it from the DG environment of the database
Any ideas or option are very welcome
Jesus