Pro Oracle Database 18c Administration: Manage and Safeguard Your Organization’s Data

© Michelle Malcher and Darl Kuhn 2019

Michelle Malcher and Darl KuhnPro Oracle Database 18c Administrationhttps://doi.org/10.1007/978-1-4842-4424-1_9

9. Views, Synonyms, and Sequences

Michelle Malcher¹  and Darl Kuhn²

(1)

Huntley, IL, USA

(2)

Morrison, CO, USA

 

This chapter focuses on views, synonyms, and sequences. Views are used extensively in reporting applications and also to present subsets of data to users. Synonyms provide a method of transparently allowing users to display and use other users’ objects. Sequences are often utilized to generate unique integers 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 ...