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 nosql faster than sql?

0 Answers  

What is the advantage of index in sql?

0 Answers  

Why primary key is required?

0 Answers  

Explain ttitle and btitle.

0 Answers  

What is a natural join?

0 Answers  




What is difference between left and right outer join?

0 Answers  

In what condition is it good to disable a trigger?

0 Answers  

What is trigger in sql and its types?

0 Answers  

HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM

3 Answers  

What is trigger point?

0 Answers  

i want to display 1 to 10 numbers using one select statement.

18 Answers   HCL, Nyros, Oracle,

How do I make sql search faster?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories