Home » SQL & PL/SQL » SQL & PL/SQL » Table related view
Table related view [message #4443] Tue, 10 December 2002 01:32 Go to next message
arun
Messages: 67
Registered: January 2000
Member
Question :

How we'll see the list of view related to particular one table?

In user_views or all_views, tbale_name is not a column name .
Could you please help me out ?
Quick response would be highly appreciated?

Regards
Arun

EMAIL_ID : arunocp@hotmail.com
Re: Table related view [message #4445 is a reply to message #4443] Tue, 10 December 2002 07:05 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
SQL> SELECT * FROM CAT;

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
EE                             TABLE
V1                             VIEW
V2                             VIEW
V3                             VIEW

SQL> select name from user_dependencies
  2  where  type='VIEW'         and
  3         referenced_name='EE' and
  4         referenced_type='TABLE';

NAME
------------------------------
V1
V2
V3

Previous Topic: width change of one column
Next Topic: Connecting to a database and using an sql procedure to modify objects database
Goto Forum:
  


Current Time: Thu May 16 15:35:54 CDT 2024