Hi Gurus,
I have a doubt. I want to list all the tables that has 0 rows. I can do this by analayzing the tables and select num_rows from dba_tables where rows=0 . Since i cannot afford to analyze the tables, is it possible to write a small pl/sql code which does this..
May be something like this...
declare a variable
open a cursor
select table_name from dba_tables till notfound
begin
fetch cursor into variable
select count(*) from variable
if row count is = 0
print the variable
do this iteration till last table name
exit
The problem is that i donot know exact pl/sql syntax and i will really appreciate if someone helps me out with this task.
Thanks in advance for your time
Bala