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?
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 update query?
what is blob? : Sql dba
How to Declare Fixed Length String Value In PL SQL
how to convert numeric values to character strings? : Sql dba
how to drop an existing index in mysql? : Sql dba
Can we use distinct and group by together?
Can ddl statements be used in pl/sql?
what is query cache in mysql? : Sql dba
how to install mysql? : Sql dba
What is the difference between sql and t sql?
What is the difference between an inner join and an outer join?
What are the types of queries in sql?
Can we insert delete data in view?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
Does sql profiler affect performance?