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

What is the difference between in and between in sql?

0 Answers  

Is pl sql a scripting language?

0 Answers  

What is the difference between having and a where in sql?

0 Answers  

what is query cache in mysql? : Sql dba

0 Answers  

how to show all tables with 'mysql'? : Sql dba

0 Answers  




What is sql exception?

0 Answers  

What are the blocks in stored procedure?

6 Answers   Microsoft,

Is grant a ddl statement?

0 Answers  

what are properties of a transaction? : Sql dba

0 Answers  

How will you make performance better for application including front end and back

2 Answers   Metric Stream,

How is debugging done?

0 Answers  

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,

For more SQL PLSQL Interview Questions Click Here
Categories