Re: Clueless Newbie Question about Synonyms

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 7 Apr 2005 05:08:08 -0700
Message-ID: <1112875688.318274.242260@o13g2000cwo.googlegroups.com>

Keith wrote:
> "Alan" <not.me_at_uhuh.rcn.com> wrote in message
> news:0685e.452$Zn3.67_at_trnddc02...
> >
> > "Keith" <keith.wilby_at_baeAWAYWITHITsystems.com> wrote in message
> > news:425503e0$1_1_at_glkas0286.greenlnk.net...
> >> What's the difference between a synonym and a view? The stuff
I've read
> >> from a Google search suggests that a synonym is another name for a
table
> > or
> >> view, but how can that be if you can create a synonym as an
object?
> >
> > A view is stored SQL. A
> > synonym is another name for something.
> >
> Are you saying that a synonym can be a view or a table? If I create
a
> synonym based upon a view then that's just more stored SQL?

If you are a newbie... you can find this sort of info. easily in the docs at http://tahiti.oracle.com.

It took me less then 30 seconds to get to this, http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c11schem.htm#CNCPT711

Regards
/Rauf Received on Thu Apr 07 2005 - 07:08:08 CDT