Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

find tables which have no data

sql enthusiastJun 16 2015 — edited Jun 16 2015

Hi Guys,

I have the schema name but want to find out the name of all those tables which do not have any data , possibly no of records=0.

I also want to find then from those tables which do have data name of columns and then I want to do search on that columns with column name

Need some assistance. Your help would be really appreciated.

Thanks
This post has been answered by Manik on Jun 16 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 14 2015
Added on Jun 16 2015
7 comments
2,467 views