Owner for public synonym
632571Apr 7 2008 — edited Apr 7 2008Hi,
I am new to oracle.Help me. What is th owner name for public synonym?
( EG)
I logged in user -> SWITCH
For table
Syntax : select * from objectowner.objectname
select * from SWITCH.table name -->Working fine
Like that how to query public synonym
select * from SWITCH.synonym name -> Failed
select * from [public].synonym name -> Failed
Any way
select * from synonym name -->Working fine
But i need the object owner name . Any idea?