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

Is crud a cuss word?

1040

In a distributed database system, can we execute two queries simultaneously?

1102

What is a pl/sql block?

1240

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7374

How do I create a sql database?

1011

how to see the create table statement of an existing table? : Sql dba

1031

Are left and right joins the same?

1096

What are the types of join in sql?

1112

What is difference between nchar and nvarchar?

1038

Can triggers stop a dml statement from executing on a table?

1114

What is primary and foreign key?

1070

What are the advantages of sql? Explain

1116

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

977

How to Execute a Package in PL/SQL.?

1218

Is pl sql better than sql?

1046