Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6919 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 is union and union all keyword in sql and what are their differences?
How do I pipe the output of one isql to another?
What is the difference between functions, procedures, and packages in pl/sql?
How can I get the number of records affected by a stored procedure?
Which are the different types of indexes in sql?
Can we create table inside stored procedure?
What is data abstraction in sql?
How do I run a pl sql program?
What is dialect in sql?
Can ddl statements be used in pl/sql?
Do stored procedures prevent sql injection?
Can you upgrade sql express to full sql?
What are the two characteristics of a primary key?
What are the disadvantages of not performing database normalization?
What are the basic techniques of indexing?
