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

Why is sql*loader direct path so fast?

1090

How many disk partitions should I have?

974

Define concurrency control. : Transact sql

1152

What are different types of indexes?

995

Why do we use partitions in sql?

1032

Why function is used in sql?

923

what is an alias command? : Sql dba

1073

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

1040

What do you mean by table in sql?

974

what is myisam? : Sql dba

1054

Is it possible to include an insert statement on the same table to which the trigger is assigned?

997

What is view? Can we update view

1411

How many sql statements are used?

998

Why truncate is used in sql?

980

What is data definition language?

1080