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
- 6018 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
What are different types of indexes?
Can we insert in sql function?
Define concurrency control. : Transact sql
What is difference between sql and excel?
How do I view output in sql developer?
Define SQL and state the differences between SQL and other conventional programming Languages?
Does asenumerable execute the query?
What is an index in sql with example?
How to write html code in pl sql?
How do I run a program in pl sql?
When can we use the where clause and the having clause?
Why join is faster than subquery?
What are the two characteristics of a primary key?
What is the use of nvl function?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
