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

Can a procedure in a package be overloaded?

749

How can I make sql query run faster?

750

What is foreign key sql?

741

What is character functions?

742

What is group by in sql?

743

What is package in pl sql with an examples?

725

What is the benefit of foreign key?

711

How do I run sql?

826

What is the limitation on the block size of pl/sql?

694

Is it possible to update views?

706

Compare sql & pl/sql

769

Determine if oracle date is on a weekend?

760

How many commands are in sql?

712

How do you break a loop in pl sql?

722

How do I start pl sql?

665