The fine manual tells all.
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14220/depend.htm#sthref1132
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist
On 5/15/06, genegurevich@xxxxxxxxxxxxxxxxxxxxx < genegurevich@xxxxxxxxxxxxxxxxxxxxx> wrote:
Hi all:
If I have a table named TABLE in a database, a public synonym named TABLE that points to this database and a private synonym TABLE that points to a table called TABLE2, what is the order in which these objects will be picked by Oracle? Is that - private synonysm followed by public synonym followed by the table?
In other words if I execute select * from TABLE and I have a private