RE: Views for a table

From: Tim Fleury <Tim_Fleury_at_perlegen.com>
Date: Fri, 23 Jan 2004 10:39:25 -0800
Message-ID: <F001.005DDFDD.20040123103925@fatcity.com>

Message

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

-----Original Message-----
From: Mauricio "Vélez [mailto:oraclemavelgo@yahoo.com]
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!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Fleury
  INET: Tim_Fleury_at_perlegen.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Jan 23 2004 - 12:39:25 CST