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

Can a foreign key be null?

1144

What is sql profiler in oracle?

1162

Define the select into statement.

1112

What are different types of keys?

1176

What is meaning of <> in sql?

1131

Can we use joins in subquery?

1229

What is sql*loader and what is it used for?

1222

How to create your own reports in sql developer?

1066

Explain how to use transactions efficiently : transact sql

1017

Why do we need sharding?

1049

Is sql dba a good career? : SQL DBA

1049

how to install mysql? : Sql dba

1161

What does varchar include?

995

how do you tune the slow running queries in oracle db , explain the methodology

3235

What is a sql*loader control file?

1344