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 update query?

983

what is blob? : Sql dba

1149

How to Declare Fixed Length String Value In PL SQL

1155

how to convert numeric values to character strings? : Sql dba

1107

how to drop an existing index in mysql? : Sql dba

1069

Can we use distinct and group by together?

1057

Can ddl statements be used in pl/sql?

1145

what is query cache in mysql? : Sql dba

1037

how to install mysql? : Sql dba

1110

What is the difference between sql and t sql?

1036

What is the difference between an inner join and an outer join?

1027

What are the types of queries in sql?

1086

Can we insert delete data in view?

951

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1111

Does sql profiler affect performance?

995