Skip to main content

Views, Synonyms, and Sequences

  • Chapter
  • First Online:
Pro Oracle Database 18c Administration
  • 774 Accesses

Abstract

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 54.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Author information

Authors and Affiliations

Authors

Rights and permissions

Reprints and permissions

Copyright information

© 2019 Michelle Malcher and Darl Kuhn

About this chapter

Check for updates. Verify currency and authenticity via CrossMark

Cite this chapter

Malcher, M., Kuhn, D. (2019). Views, Synonyms, and Sequences. In: Pro Oracle Database 18c Administration. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-4424-1_9

Download citation

Publish with us

Policies and ethics