Oracle SQL Developer. Find referenced views of synonyms

Question

Hello in the PL/SQL Developer beneath the category synonyms there is a tab (referenced by), which displays referenced views of a synonym.

On my system there is no PL/SQL Developer installed. So is there any function in the normal Oracle SQL Developer or a query how I can retrieve the same information as in the PL/SQL Developer ?

Thanks in advance

Answer 1

Hi! Hope this can help you ...

select o1.owner,o1.object_name, o2.owner,o2.object_name 
  from PUBLIC_DEPENDENCY t, Dba_Objects o1, Dba_Objects o2
 WHERE t.object_id=o1.object_id
   AND t.referenced_object_id=o2.object_id
   AND o1.object_name="your_object_name"