Re: How does oracle resolve a reference to an object

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: genegurevich@xxxxxxxxxxxxxxxxxxxxx
  • Date: Fri, 26 May 2006 09:55:01 -0700

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

Other related posts: