Joined: 25 Jun 2007 Posts: 196 Location: Bangalore
I have table as input. I would like to have query on system tables which output list of views defined using the table passed as input. In the output, I would like to have the views in output which defined from view (which defined from table) too.
for example, Let say tables t1,t2,t3,t4
View v1 is defined as follows.
select * from t1,t2 where ...
View v2 is defined as follows
select * from v1,t3 where ...
View v3 is defined as follows
select * from v2,t4 where ...
Note: For all views v1,v2,v3 one of the underlying table is t1