Sign Up Login


  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

When you have to use a default "rollback to" savepoint of plvlog?

0 Answers  

What are the pre requisites?

1 Answers  

Name three sql operations that perform a sort.

0 Answers  

What is a recursive stored procedure?

0 Answers  

How do I run a query in pl sql developer?

0 Answers  




What is the maximum number of triggers, you can apply on a single table?

0 Answers  

What is the basic structure of PL/SQL ?

6 Answers  

I want to execute a piece of code before calling a procedure. How to achieve it?

1 Answers   Oracle,

Can you do multiple joins in sql?

0 Answers  

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

0 Answers  

what is isam? : Sql dba

0 Answers  

Why do we need a foreign key?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories