Abstract
This chapter covers views, a very important component of the relational model (see Ted Codd’s rule 6, in Chapter 1). The first section explains the concept of views. The second section discusses how to use the CREATE VIEW command to create views. In the next section, you’ll learn about the various ways you can use views in SQL, in the areas of retrieval, logical data independency, and security.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Editor information
Rights and permissions
Copyright information
© 2009 Lex de Haan, Daniel Fink, Tim Gorman, Inger Jørgensen, Karen Morton
About this chapter
Cite this chapter
de Haan, L., Fink, D., Gorman, T., Jørgensen, I., Morton, K. (2009). Views. In: Gennick, J., et al. Beginning Oracle SQL. Apress. https://doi.org/10.1007/978-1-4302-7196-3_10
Download citation
DOI: https://doi.org/10.1007/978-1-4302-7196-3_10
Publisher Name: Apress
Print ISBN: 978-1-4302-7197-0
Online ISBN: 978-1-4302-7196-3
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books