SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

view to check create synonym statement

User_FZ3ZWJul 7 2021

Hi Team,
I need to check the create synonym statement for multiple synonyms .
for e.g. Above statement I need to retrieve from database
CREATE OR REPLACE PUBLIC SYNONYM ravi FOR hr.ravi_m;

I know in SQLdeveloper tool. We can go to the left side and filter the synonym and then go to sql tab.
But I need to check for multiple synonyms. is there any system view where we can retrieve this.

Thanks in Advance

This post has been answered by Frank Kulash on Jul 7 2021

Jump to Answer

Added on Jul 7 2021

4 comments

3,913 views

1 mention