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 application trigger?

990

What is nosql vs sql?

1174

What are the uses of sysdate and user keywords?

1098

Does sql*plus also have a pl/sql engine?

1074

Is big data nosql?

939

What does the file extension accdb stand for?

968

What is union, minus and interact commands?

1283

What found sql?

939

What is the difference between having and a where in sql?

1097

define data blocks ? : Sql dba

975

What are the types of sql commands?

1094

what are the advantages of using stored procedures? : Sql dba

1101

what are the 'mysql' command line arguments? : Sql dba

1133

State some properties of relational databases?

1049

How does sql developer connect to oracle database?

997