Hi,
I am trying to create a pl/sql block that would loop through the user_tables and counting the number of rows and then printing them.
I am new to pl, and so far got the following
declare
begin
for i in (select table_name from USER_TABLES where table_name LIKE 'POPULATION%') loop
count(*)
end loop;
-- dbms_output.put_line(cnt);
end;
Can someone please point me in the right direction?
Thanks.