Difference between revisions of "Finding out information on a view"

SELECT 
  name , 
  TYPE , 
  referenced_name , 
  referenced_type
FROM 
  user_dependencies 
WHERE 
  name = 'VIEW_NAME' AND 
  TYPE = 'VIEW' AND  
  referenced_type = 'TABLE';