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 is the use of double ampersand (&&) in sql queries?

1176

How can we make an if statement within a select statement?

1013

What is asqueryable?

973

How to display the records between two range in Oracle SQL Plus?

1147

What is difference between sql and mysql?

1133

What is the difference between clustered and non-clustered index in sql?

1016

How do I know if I have sql express or standard?

1032

Can a composite key be null?

979

What is the difference between mdf and ndf files?

1119

What is pl sql in oracle?

1043

Does sap use sql?

996

What is sap sql anywhere?

1079

explain the difference between delete , truncate and drop commands? : Sql dba

1093

Is and as keyword in pl sql?

961

What is sql and how does it work?

1175