Public Synonyms, DBA Objects Views

[Ameen]

Hi
1) I there a way to display all public synonyms in "Browser Folder" Window?
2) I tried to define a new folder to retieve some information from DBA Object Views but I found that SQL sentence made automatically by PLSQL-Developer is made on ALL Objects Views, How can I let it select from DBA Object Views?
I am using pld version 6.0.4.906
Thanks.

 

[Marco Kalter]

1) I there a way to display all public synonyms in "Browser Folder" Window?

Create a user-defined folder and set the Where Clause property to:

object_type='SYNONYM' and owner='PUBLIC'

How can I let it select from DBA Object Views?

Go to Tools > Preferences > Oracle/Options page, and enable the "Use DBA views if available" option.