RE: Views for a table

[Tim Fleury]

Title: Message

Query DBA_DEPENDENCIES where type='VIEW' and referenced_name='STUDENTS' and referenced_type='TABLE'.

-----Original Message-----
From: Mauricio "Vélez [mailto:[EMAIL PROTECTED]
Sent: Friday, January 23, 2004 9:50 AM
To: Multiple recipients of list ORACLE-L
Subject: Views for a table

Hi everybody

 

I have the following question

 

How can I query a table's views?

 

For example I have the table students and I want to know the views related to this table.

 

Thanks,

Mauricio Vélez

---

Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!