List all Synonyms in Oracle

Asked

Viewed 2,183 times

2

How do I list all the Synonyms(synonyms) present in my database? I need to know which ones are created to compare between banks what exists. I tried with the code below but does not return synonyms:

select * from all_objects
oracle pl-sql

1 answer

1


select * from all_synonyms;

There’s a view for every kind of object you create. example: all_tables, all_views, all_procedures......

  • Pow vacillated, solved. kkkk managed to bring the Synonyms. thanks Renato.

  • When you don’t know which metadata table to use... select * from DICT

  • I prefer to use the user_synonyns, by bringing only those that are valid, from the connected user.

Browser other questions tagged oracle pl-sql

You are not signed in. Login or sign up in order to post.