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 denormalization in a database?

1 Answers  

How do I count records in sql?

1 Answers  

What is a primary key sql?

1 Answers  

What is difference sql and mysql?

1 Answers  

What does plv msg allows you to do?

1 Answers  

Can a table contain multiple primary key’s?

1 Answers  

Begin For j in 4403201000 .. 4403202000 Loop If mod (j, 100) = 0 then Dbms_output.put_line (j); End if; End loop; End; what will be the output of this question

7 Answers   TCS,

Explain autonomous transaction.

1 Answers  

What is the order of sql select?

1 Answers  

How show all rows in sql?

1 Answers  

What is not null in sql?

1 Answers  

what is an index? : Sql dba

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories