A view is a tailored presentation of the data stored in the database. In layman’s terms, a view is a stored query. It can be used just as if it was a table but the key distinction is that a view does not store data — it is simply a stored query definition. However, the data is accessible through the view just as if you were accessing a normal table. You can select from it, join to it, and in some cases, you can INSERT, UPDATE, and DELETE from it. As such, a view can be considered a virtual table. There are four types of views in Oracle:
KeywordsObject Type Execution Plan Relational View Object View Data Dictionary
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
Unable to display preview. Download preview PDF.
© Apress 2002