LLI Wiki — My Digital Knowledge Base

Oracle: difference between a view and a synonym

What a view and a synonym are in Oracle, and when to use each.

A view and a synonym both give access to Oracle data under a name other than the original table, but they serve different purposes.

View

A view is a virtual table.

Main advantages of views:

Synonym

A synonym is an alternate name given to a table, view, sequence or program unit.

Mastodon LLIMastodon SocialFosstodon