Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How does oracle resolve a reference to an object

How does oracle resolve a reference to an object

From: <genegurevich_at_discoverfinancial.com>
Date: Mon, 15 May 2006 16:11:59 -0500
Message-ID: <OFC29752DD.BB04C72E-ON8625716F.00742A9B-8625716F.00747305@discoverfinancial.com>


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 synonym TABLE that points to TABLE2,
will that SQL go against the TABLE2?

thank you

Gene Gurevich

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 15 2006 - 16:11:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US