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