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

Define commit, rollback and savepoint?

571

what is the difference between a local and a global temporary table? : Sql dba

549

Can we use commit inside a trigger?

517

What is pl sql quora?

639

Explain how can you save or place your msg in a table?

593

Does pl/sql support create command?

572

Is inner join faster than left join?

629

What is orm in sql?

533

tell us something about heap tables. : Sql dba

596

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

661

how to present a past time in hours, minutes and seconds? : Sql dba

551

Why do we use set serveroutput on?

514

What is oracle and pl sql?

659

What are system versioned tables?

548

Can we insert data into materialized view?

500