nirmal1in

 Profile Answers by nirmal1in Questions by nirmal1in

• Feb 7th, 2011

 

You find the details in dictionary tables

SELECT * FROM dba_views

WHERE view_name = <view name >

TEXT column contains the actual query which used while creating views and this will give details what are all tables used.

Balakrishna12207

 Profile Answers by Balakrishna12207 

• Feb 7th, 2011

 

SELECT * FROM dba_views WHERE View_name=;

Text column can contain "The details of view and table"

Prem_p

 Profile Answers by Prem_p 

• Apr 28th, 2011

 

Guys, 

you don't need a dba privilege for this.

Run the query:

select * from USER_DEPENDENCIES where  type='VIEW' and name=''

This will give you the dependent object information (name , type of the object and dependency type) .

i.e, if the view is created on 2 tables and 1 function and 1 proc, it'll show object name and type in four rows.