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
- 6388 Views
- I also Faced
- E-Mail Answers
Answer Posted / kavitha
select table_name,num_rows from user_tables
where num_rows = 0
| Is This Answer Correct ? | 24 Yes | 4 No |
Post New Answer View All Answers
what is a join? : Sql dba
How can we solve sql error: ora-00904: invalid identifier?
What has stored procedures in sql and how we can use it?
What is on delete set null?
what are the different type of normalization? : Sql dba
Explain the methods used to protect source code of pl/sql.
what are null values? : Sql dba
which operator is used in query for pattern matching? : Sql dba
What is the difference between clustered and non-clustered indexes?
What is join view in sql?
What does pragma mean?
what are the drivers in mysql? : Sql dba
what is row? : Sql dba
Can function return multiple values in sql?
What is the use of partition by in sql?
