Views on tables

if you have the right to select dba_views (data dictionary views that show all objects in the database)
you may submit the following statement:

• snip ------------------------- select * from dba_dependencies where REFERENCED_OWNER = <owner_of_table> and REFERENCED_NAME = 'INFO_CONTR_TEXT' and REFERENCED_TYPE = 'TABLE' and type = 'VIEW';
  --------------snap ---------------------------
  Gerd www.BITS-on-the.net

-----Ursprüngliche Nachricht-----

Von: Cheong Chen Heong [mailto:ccheong_at_telco.sema.com.my] Bereitgestellt: Mittwoch, 4. Juli 2001 05:10 Bereitgestellt in: server
Unterhaltung: Views on tables
Betreff: Views on tables

Hello

Given a table (INFO_CONTR_TEXT), how can I find out if there is/are any view/views built on it?

Thank you.

Regards,
Chen Received on Sat Jul 21 2001 - 16:26:34 CDT