Thursday, November 13, 2014

how to search one view used in other views in oracle?

SELECT * FROM User_Dependencies
WHERE TYPE IN
('PACKAGE',
'PACKAGE BODY', 'TYPE BODY',
'TRIGGER',
'FUNCTION',
'VIEW',
'SYNONYM',
'TYPE'
)
AND REFERENCED_OWNER = 'SERVERDB'
AND REFERENCED_NAME = 'SERVERS_V';


No comments:

Post a Comment