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!

Need some solution over Synonyms

Andrew RDec 6 2022

Hi All,

I have created two synonym public and private synonym with same name as "EMP_SYN" and both have status "valid". Now I want to get data from public synonym.Bcoz whenever I select EMP_SYN it is giving the result from the private synonym... is there any way to get data from public synonym. please help.

Regards,
Shajin

Added on Dec 6 2022

#11g, #12c, #database, #oracle, #sql

3 comments

234 views