Use the column "blocks" from the view user

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 / arpan

Answer Posted / arpan

Use the column "blocks" from the view user_tables. eg:
select * from user_tables u where u.blocks = 0;

Is This Answer Correct ?

5 Yes

6 No

Please Help Members By Posting Answers For Below Questions

How can I delete duplicate rows?

963

what is 'mysqladmin' in mysql? : Sql dba

971

what is query cache in mysql? : Sql dba

990

How do you update sql?

909

What are triggers in sql?

971

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

998

What is mutating error in pl sql?

961

how do you know the version of your mysql server? : Sql dba

935

What is using in sql?

1011

What is self-join and what is the requirement of self-join?

1088

What are all ddl commands?

1011

What is an inner join sql?

952

What are all the ddl commands?

1112

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2107

What are variables in pl sql?

1090