Re: How to read table using Synonym

From: HansF <News.Hans_at_telus.net>
Date: Thu, 01 Sep 2005 21:35:38 GMT
Message-Id: <pan.2005.09.01.21.39.55.111349@telus.net>

On Thu, 01 Sep 2005 14:20:49 -0700, sunny076 interested us by writing:

> Hi,
>
> I am wondering if anyone can tell me how I can read (select) data from
> a synonym. I am getting the synonym list and want to be able to use
> orcale SQL to read/select it.
>
> Thank you in advance,
>
> Sunny

Are you perhaps being confused about the definition of a synonym? From the Oracle documentation at http://docs.oracle.com, specifically from the Oracle9i SQL Language Reference manual, under 'CREATE SYNONYM' section, we learn that:

Use the CREATE SYNONYM statement to create a synonym, which is an alternative name for a table, view, sequence, procedure, stored function, package, materialized view, Java class schema object, user-defined object type, or another synonym.

Managing a synonym is discussed in the Oracle Dtabase Administrator's Guide in the section titled 'Managing Synonyms', where you find out the basics of creating and dropping, asd well as a bunch of hints about how and when to set them up.

Finally, use them just as you would use the object (table view sequence procedure etc) for which the synonym is, well, a synonym.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***

Received on Thu Sep 01 2005 - 16:35:38 CDT