How to find table present in views in Oracle Database

How to find table present in views in Oracle Database


SELECT REFERENCED_OWNER, REFERENCED_NAME

FROM DBA_DEPENDENCIES

WHERE OWNER = '&owner_name'

  AND NAME = '&view_name'

  AND TYPE = 'VIEW'

  AND REFERENCED_TYPE = 'TABLE';

Comments