Tables on which view is made

[khushbubhalla]

Is there a way to find the list of tables on which a view is made using system tables in oracle

[rectoverso]

Is there a way to find the list of tables on which a view is made using system tables in oracle

this can do it;

SELECT OWNER, REFRENCED_NAME
FROM ALL_DEPENDENCIES
WHERE REFERENCED_TYPE = 'TABLE'
AND NAME = 'YOURVIEW'
AND TYPE = 'VIEW';

You can use a dba view also. You must to connect as sysdba. then script is :

SELECT OWNER, REFRENCED_NAME
FROM DBA_DEPENDENCIESWHERE REFERENCED_TYPE = 'TABLE'
AND NAME = 'YOURVIEW'
AND TYPE = 'VIEW';

[jigs]

If you use toad, you can

write a table name in toad screen
press F4 and it will give you the view definition and the query on which the view is based on.