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 are character functions in sql?

0 Answers  

oracle is compiler or interpretter,can any one tell me the answer?

9 Answers   Satyam,

How do you identify a primary key?

0 Answers  

What is the location of pre_defined_functions.

0 Answers  

what is the difference between stored procedure and packaged procedure

1 Answers   Google, Infosys,




What is difference sql and mysql?

0 Answers  

What is nvarchar in sql?

0 Answers  

there are .......different types of serializability

1 Answers   Wipro,

what is difference between procedure and function, procedure and trigger?

8 Answers   iFlex,

What is nosql vs sql?

0 Answers  

what is a relationship and what are they? : Sql dba

0 Answers  

Are sql connections encrypted?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories