| |
GeekInterview.com > Tech FAQs > PL/SQL
| Print | |
Question: How to write a query or procedure or function to retrieve all the tables from database where the table dont have any data (no rows).
Answer: Database has 100 tables and some of the tables dont have any data. I want to pullout those table names from database in Oracle. |
| June 06, 2008 01:07:21 |
#3 |
| sr_2407 |
Member Since: February 2008 Total Comments: 1 |
RE: How to write a query or procedure or function to retrieve all the tables from database where the table dont have any data (no rows).
|
select table_name ,num_rows from user_tables
where num_rows=0 |
| |
Back To Question | |
