How do we view the query used while creating a View table? i.e How to find the dependencies of a view table.

sinhasaurabh014

 Profile Answers by sinhasaurabh014 Questions by sinhasaurabh014

• Sep 4th, 2008

If you have toad, you can see everything. Just navigate to view throgh schema browser and check under the tabs "view". select your view and check all the properties from it.

vermapradeep1980

 Profile Answers by vermapradeep1980 Questions by vermapradeep1980

• Aug 30th, 2008

Try this one.. select text from user_view where view_name ='viewname'pradeep

Answer Question  Select Best Answer