Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
what is the difference between view and synonym in oracle?
5 Answers
- 2 decades agoFavorite Answer
A view is a stored query you can access as a (read-only) table. It is often used as an interface to other modules/programs. The view stays the same (name, columns, etc.) but the underlying query and/or tables can change without affecting the calling module.
A synonym is just that: another name for an existing object (table, view, stored procedure) in oracle. You usually create public synonyms to access objects in another schema without referencing the schema.
- 6 years ago
View can be created using multiple tables.
View is logical and does not occupies space.
Synonym can be created for single table, view, sequence or index.
Synonym is physical and needs space.
Source(s): Oracle database by kelvin loney. - How do you think about the answers? You can sign in to vote the answer.
- 6 years ago
view:-
1>view does not occupies any space for data.
2> view are used to restrict the column or data to access by another user.
3>If you have to change in view data it will change on base table data.
4>view is logical existence.it does not contain data.
synonym:-
1> synonym occupies space for data.
2> synonym is naming convension.
3> If the table or data are in different-different schema so without using schema name we will used synonym.
4> synonym is physical existence.
(ramesh kumar singh)
