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

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

Re: How does oracle resolve a reference to an object

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 26 May 2006 09:55:01 -0700
Message-ID: <bf46380605260955m3d3ff3d7vf90a720254c48028@mail.gmail.com>


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_at_discoverfinancial.com <
genegurevich_at_discoverfinancial.com> 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
>
-- http://www.freelists.org/webpage/oracle-l
Received on Fri May 26 2006 - 11:55:01 CDT

Original text of this message

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