Skip to Main Content

APEX

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!

Is there a good way to find all references to a table or column?

John Ramuta-OracleMay 28 2014 — edited May 30 2014

I recently inherited a large apex application, and am getting requests to make changes to it.  I would like to ensure that any changes that I might make to a table or a column of a table will only affect the application pages that I believe are involved.  However, the application is large, and I'm assuming that it is possible for other pages may reference the same column or table, and that I would be unaware of those references (at least, until after it breaks once I change the column or table).

My question is this:  Is there a built-in report, or a way to query apex, that will tell me ALL the references that an application makes to a particular table or column?  That way I could correct all the pages in the application, instead of waiting for it to break.

Thanks!

John

This post has been answered by jwellsnh on May 28 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 27 2014
Added on May 28 2014
2 comments
2,277 views