Home » SQL & PL/SQL » SQL & PL/SQL » find views using particular column (oracle 10g)
find views using particular column [message #296064] Thu, 24 January 2008 07:50 Go to next message
moschen
Messages: 25
Registered: April 2007
Junior Member
Hi,

is there an easy way to find out all views that are dependant on a particular column? I can find dependant tables (xxx_DEPENDENCIES) but I can not find dependant columns, as xx_VIEWS uses a long to store the text and therefore ".. like .." does not work.

Best regards,
M.

PS: The column names I am looking for are unique per schema
Re: find views using particular column [message #296065 is a reply to message #296064] Thu, 24 January 2008 07:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No easy way.

Regards
Michel
Re: find views using particular column [message #296070 is a reply to message #296065] Thu, 24 January 2008 08:41 Go to previous message
moschen
Messages: 25
Registered: April 2007
Junior Member
nevermind, i did it now in plsql
Previous Topic: to find the no.of procedures in my account
Next Topic: I need help regarding the CASE statement
Goto Forum:
  


Current Time: Wed Dec 07 10:31:39 CST 2016

Total time taken to generate the page: 0.10430 seconds