Oracle: Views or Synonyms?

Soldato
Joined
5 Dec 2003
Posts
2,716
Location
Glasgow
Hey struggling with a past paper question for my databases module here. It's asking when is best to use views or synonyms? And I don't know the answer, I'm reading a page on the Oracle site about them but nothing is really jumping out at me, they still seem to be pretty alike to me.
 
Well the question is a little trickier than I made out, it's the 2nd part and it's asking me to implement location transparency on a number of queries I have just come up with and give justification for my choice. But I would just use views on the lot of them and I don't know why I would do that. It's possible to use synonyms on them as well.
 
Back
Top Bottom