Schema for Synonym

Hi
I am new to oracle. Can any one help me how to access public synonym using schema name?


(Eg) Table name : Employee Owner : swift

select * from swift.Employee --> Its working

Like above i need for public synonym : SynEmployee

select * from SynEmployee --> Its working
select * from swift.Employee --> Giving error
Instead of swift what i have to use for public synonym?

In simple words,
In sql we will use dbo.object name in query.Like that i am searching for oracle public synonym

Thanks in Advance
Regards,
Arun

while you try to access the synonym,what is the error you are getting ?

What you are saying is in conflict with the way public synonyms are used. You create a public synonym so you don’t have to put the owner. In the query. Please let me know if you need more help.