When I create a synonym on a package the detail tab shows it twice:
This is a bit confusing, until you realise the underlying statements joins via OWNER and NAME. Unfortunately Dba_synonyms doesn't give any information about the type, so package spec and package body are being returned.
Is this intended behaviour? I would expect package spec only (or a clear destinction between the two in the Details tab).
Best regards,
Sabine