Re: Difference between oracle Synonyms and Views.

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Tue, 28 Oct 2003 17:53:54 +0200
Message-ID: <3f9e9113$1_1@news.estpak.ee>

Hi!

View is basically a stored SQL statement, it enables you to reduce coding efforts, enforce some security constraints etc. Since it's nature, view can reference several tables and other views, as any normal SQL statement can.

Synonym, instead, is plain reference to a specifc object - in other words, an alias. It can reference only one object and it doesn't contain any SQL clauses like views do.

Tanel.

"Prem" <premratan_at_hotmail.com> wrote in message news:2f7d06ff.0310271729.742d2218_at_posting.google.com...
> Hi oracle gurus,
>
> I am confused about the synonyms in Oracle. I just wanted to know the
> difference between Synonyms and views.
> Please help me in this matter.
> Thank you in advance.
>
> Prem Kalani.
Received on Tue Oct 28 2003 - 09:53:54 CST