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 an implicit commit?
Does sql view stored data?
What is an invalid partition table?
Does group by remove duplicates?
What is the difference between clustered and non-clustered indexes?
Does oracle use sql?
What are different functions in sql?
Show how functions and procedures are called in a pl/sql block.
how can I make a script that can be bi-language (supports english, german)? : Sql dba
How can I tell if sql is running?
Does truncate table reset auto increment?
what are local and global variables and their differences? : Sql dba
Which is better stored procedure or query?
Where the sql database files are stored?
What is the purpose of a secondary key?