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';
SELECT REFERENCED_OWNER, REFERENCED_NAME
FROM DBA_DEPENDENCIES
WHERE OWNER = '&owner_name'
AND NAME = '&view_name'
AND TYPE = 'VIEW'
AND REFERENCED_TYPE = 'TABLE';
Comments
Post a Comment