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: Order of table_name resolution

Re: Order of table_name resolution

From: <jkstill_at_cybcon.com>
Date: Wed, 14 Mar 2001 12:26:19 -0800
Message-ID: <F001.002CC7AF.20010314084547@fatcity.com>

Here's more than you wanted to know about name resolution:

http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a77069/d_names.htm#3693

Jared

On Wed, 14 Mar 2001, Cale, Rick T (Richard) wrote:

> Hi DBAs,
>
> Can someone clarify/confirm on how Oracle determines what table to use in
> select statement?
>
> For ex. If I am login as Scott and do the following:
>
> SELECT * FROM employee;
>
> Of course Oracle will use Scott.employee if it exist. If it does not exist
> but exist under another schema. Does
> Oracle look at private synonyms then public synonyms or vice versa.
>
> My guess is Oracle checks in this order. Please confirm or correct.
>
> 1. Check if table exist in current schema
> 2. Check private synonyms
> 3. Check public synonyms
> 4. 3 strikes your out with an error.
>
> Rick Cale, Science Applications International Corp.
> Phone:865-481-2198, fax:865-481-8555
> e-mail: caler_at_saic.com
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Wed Mar 14 2001 - 14:26:19 CST

Original text of this message

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