Oracle Database Discussions

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!

how do i count number of table being used in a view

760898Jul 26 2010 — edited Jul 26 2010

Hi All,

I will be really thankful if anyone please let me know about the count of number of tables being used in a view. I am using Oracle 10g Release 2 on HP-UX(11.31).
In actual I have to find views in my database with more than 5 table in join.

Thank you
Gursimran

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 23 2010

Added on Jul 26 2010

#general-database-discussions

3 comments

1,253 views