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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Clueless Newbie Question about Synonyms

Re: Clueless Newbie Question about Synonyms

From: Keith <keith.wilby_at_baeAWAYWITHITsystems.com>
Date: Thu, 7 Apr 2005 12:39:50 +0100
Message-ID: <42551a0a$1_1@glkas0286.greenlnk.net>


"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? Received on Thu Apr 07 2005 - 06:39:50 CDT

Original text of this message

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