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

What does count (*) do in sql?

1050

How can we implement rollback or commit statement in a trigger?

1083

what is sql in mysql? : Sql dba

1236

Which certification is best for sql?

1039

What is the primary key?

1000

Which one is better sql or oracle?

1013

What is difference between stored function and application function?

1288

Which is faster view or stored procedure?

1007

what is myisam? : Sql dba

1160

what is error ora-03113: end-of-file on communication channel?

1224

How does cross join work in sql?

1073

Which language is used in sql?

1116

What are sql functions? Describe the different types of sql functions?

1208

how to calculate expressions with sql statements? : Sql dba

1092

Is big data nosql?

1000