Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Clueless Newbie Question about Synonyms
"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
![]() |
![]() |