SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

what is difference between synonyms and views in sql.........?

1033266Jun 13 2016 — edited Jun 13 2016

Hi,

I am new to sql and i want to know why we are using synonyms and view's in sql , we can create synonyms on table and view's on query's this two are created based on table then why we use this two

AD of view is:

it is advance of synonyms

useful for application designing

we can display partial part of table

could you please tell me more than this with example

Thanks

Raghu

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 11 2016

Added on Jun 13 2016

20 comments

12,083 views