select table_name,num_rows from user_tables where num

If 100 tables are there in user_tables.I want to find in which
table zero records are there with table name.Is it possible?

Question Posted / kavitha

Answer Posted / kavitha

select table_name,num_rows from user_tables
where num_rows = 0

Is This Answer Correct ?

24 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is difference between stored function and application function?

1095

Can we commit in trigger?

919

What is clause in sql?

1050

How can we optimize a sql query?

982

What is rownum?

921

What do you mean by stored procedures?

950

Explain autonomous transaction.

1090

When do we use triggers?

1025

What is sql table?

902

Can we edit a view in sql?

923

Can you have more than one trigger on a table?

939

How do I view a table in sql?

941

What is primary key and unique key?

1043

Why trigger is used in sql?

912

What's the procedure?

861