OraFAQ Forum: SQL & PL/SQL » related to views

Home » SQL & PL/SQL » SQL & PL/SQL » related to views

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

related to views [message #153798]

Wed, 04 January 2006 03:44

jampana_anil
Messages: 8
Registered: August 2005

Junior Member

i want how to see all the views that are created for particular table

Report message to a moderator

Wed, 04 January 2006 04:18

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Views are not 'created for a particular table', they are stored SQL queries. So, I'm afraid that the only option you have is to search the view text in USER/ALL/DBA_VIEWS. But, as the TEXT column in this dictionary view(s) is a LONG, you cannot query it directly. Use a function like this one.

MHE

Report message to a moderator

Wed, 04 January 2006 04:40

Frank
Messages: 7901
Registered: March 2000

Senior Member

query user_dependencies (or all_ or dba_...):

select name
from   user_dependencies
where  type = 'VIEW'
and    referenced_name = '<your table>'

hth

Report message to a moderator

Wed, 04 January 2006 04:52

Maaher
Messages: 7065
Registered: December 2001

Senior Member

LOL, totally forgot about that. I knew I was missing something.

Excellent Frank!

MHE

Report message to a moderator

Previous Topic:	pl/sql : simple
Next Topic:	How to query from all_views based on TEXT field

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 09 08:07:56 CDT 2025