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 the table_name from the view

673366Mar 4 2009 — edited Mar 4 2009
Hi

I am stuck at one point:

Working on a form in oracle 11i GL, I have picked-up the view name from record history.

I do have sql access to the instance and want to know how to find the table_name/s for the related view.
For eg. I have a view name : GL_SETS_OF_BOOKS_V, how do i find using sql commands the table name for this view?

Thanks in Advance
Shanks
This post has been answered by OrionNet on Mar 4 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 1 2009
Added on Mar 4 2009
10 comments
1,319 views