How do I list all synonyms in my database? I need to know which ones are created to compare what exists between banks. I've tried the following code but it does not return synonyms:
select * from all_objects
List all synonyms in Oracle
0
asked by anonymous 07.11.2016 / 21:15
1 answer
0
select * from all_synonyms;
There is a view for each type of object you create. example: all_tables, all_views, all_procedures ......
08.11.2016 / 14:58