Home » SQL & PL/SQL » SQL & PL/SQL » how to know the view's defined on particlular table (merged) (sql)
how to know the view's defined on particlular table (merged) [message #427639] Fri, 23 October 2009 12:58 Go to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
i want to know the view's defined on particular table .
by giving table name in query i have to know the views defined on that.
reply me soon.
thanks in advance.
Re: how to know the view's defined on particlular table [message #427641 is a reply to message #427639] Fri, 23 October 2009 13:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
all_dependencies

Regards
Michel
Re: how to know the view's defined on particlular table [message #427642 is a reply to message #427639] Fri, 23 October 2009 13:17 Go to previous messageGo to next message
rkolli
Messages: 2
Registered: October 2009
Junior Member
Here is qry

SELECT NAME
FROM ALL_DEPENDENCIES
WHERE REFERENCED_NAME = '&1'
AND REFERENCED_TYPE = 'TABLE'
AND TYPE = 'VIEW';
how to find view's defined on particular table [message #427653 is a reply to message #427639] Fri, 23 October 2009 14:55 Go to previous messageGo to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
hi all,
i want to know the view name's defined on particular table name if exists any,
i.e just by knowing the table name i want to know the views defined on it.
please reply me soon.
Re: how to find view's defined on particular table [message #427654 is a reply to message #427653] Fri, 23 October 2009 14:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You already received 2 answers on this question, why do you post it once more?

Regards
Michel
Re: how to find view's defined on particular table [message #427667 is a reply to message #427654] Fri, 23 October 2009 21:25 Go to previous messageGo to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
i am sorry it's my mistake,
and thanks for your reply's.
Re: how to find view's defined on particular table [message #427677 is a reply to message #427667] Sat, 24 October 2009 01:03 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A mistake repeating the same 2 hors later? Alzheimer?

Regards
Michel
Previous Topic: Looking for some help with a Compare function.
Next Topic: How to sort it.
Goto Forum:
  


Current Time: Sun Dec 11 02:18:46 CST 2016

Total time taken to generate the page: 0.09745 seconds