December 2010
Intermediate to advanced
713 pages
19h 33m
English
Content preview from Pro Oracle Database 11g Administration
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
C H A P T E R 9
Views, Synonyms, and Sequences
This chapter focuses on views, synonyms, and sequences. Views are used extensively in reporting applications and also to present subsets of data to applications. Synonyms provide a means to transparently allow users to display and use other users' objects. Sequences are often used to generate unique numbers that are used to populate primary-key and foreign-key values.
Note Although views, synonyms, and sequences may not seem as important as tables and indexes, the truth of the matter is that they're ...