SQL & PL/SQL

Hi All,

There is reuirement where in we have to find the dependency information for all the tables which are used in particular view...along with remote database connections.. For this we have tried to use following query..

Select * from user_dependencies
start with name =’SAMPLE_VIEW’
connect by prior trim(referenced_name)=trim(name);

The view consists of three tables :

Create view sample_view as
select t1.col1,
T2.col2,
T3.col3,
From
Table1,
Table2@prd1,
Table3@prd2
Where
T1.col5=t2.col5
And T1.col5=t3.col5;

But the ouptut is :

name Type Reference_name Reference_type Reference_link_name
sample_view View Table1 Table null

So what will be the magic query which will give the all the tables in the view sample_view??
Desired result:


name Type Reference_name Reference_type Reference_link_name
sample_view View Table1 Table null
sample_view View Table2 Table prd1
sample_view View Table3 Table prd2

Thanks all in Advance!!