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
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......
Browser other questions tagged oracle pl-sql
You are not signed in. Login or sign up in order to post.
Pow vacillated, solved. kkkk managed to bring the Synonyms. thanks Renato.
– rodrigorf
When you don’t know which metadata table to use... select * from DICT
– Motta
I prefer to use the
user_synonyns, by bringing only those that are valid, from the connected user.– David