C H A P T E R  9

images

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.

images Note Although views, synonyms, and sequences may not seem as important as tables and indexes, the truth of the matter is that they're ...

Get Pro Oracle Database 11g Administration now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.