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?
- 2 Answers
- 5999 Views
- I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
When are we going to use truncate and delete?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
how to check server status with 'mysqladmin'? : Sql dba
What is dense_rank in sql?
Define union, minus, union all, intersect ?
What is integrity in sql?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
Where is sql database stored?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
How do I pipe the output of one isql to another?
What is scope of pl sql developer in future?
What is the purpose of the sql select top clause?
Why having clause is used in sql?
Where the sql database files are stored?
