1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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?

Question Posted / shiva

Answers were Sorted based on User's Feedback



If 100 tables are there in user_tables.I want to find in which table zero records are there with t..

Answer / kavitha

select table_name,num_rows from user_tables
where num_rows = 0

Is This Answer Correct ?    24 Yes 4 No

If 100 tables are there in user_tables.I want to find in which table zero records are there with t..

Answer / 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

More SQL PLSQL Interview Questions

Is sql free?

0 Answers  

Is t sql a programming language?

0 Answers  

Difference between truncate, delete and drop commands?

0 Answers  

explain advantages of myisam over innodb? : Sql dba

0 Answers  

What does the acronym acid stand for in database management?

0 Answers  




What is indexes?

0 Answers  

What is a Procedure ?

3 Answers  

What are hotfixes and patches?

0 Answers  

What is the primary use of normalization?

0 Answers  

How many types of sql are there?

0 Answers  

What are the string functions in sql?

0 Answers  

how to convert numeric values to character strings? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories