Experiment with dba_dependencies view.
- Kirti
--- Mauricio Vélez [EMAIL PROTECTED] wrote:
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,
The table you want to look into is USER_OTN, Column DOCUMENTATION.
On 01/23/2004 12:49:34 PM, Mauricio V?lez wrote:
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,
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 AMTo: Multiple recipients of list ORACLE-LSubject:
Mladen,
Any privileges required to view this table, or just common sense? :-)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Mladen Gogala
Sent: Friday, January 23, 2004 1:24 PM
To: Multiple recipients of list ORACLE-L
The table you want to look into is USER_OTN, Column
The only privilege you can grant to yourself :
GRANT RTFM TO user [WITH GRANT OPTION];
Igor Neyman wrote:
Mladen,
Any privileges required to view this table, or just common sense? :-)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Mladen Gogala
Sent: Friday,