Advertisement

Views

  • Sean Dillon
  • Christopher Beck
  • Thomas Kyte
  • Joel Kallman
  • Howard Rogers

Abstract

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:
  • Relational Views

  • Inline Views

  • Object Views

  • Materialized View

Keywords

Object 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.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Apress 2002

Authors and Affiliations

  • Sean Dillon
  • Christopher Beck
  • Thomas Kyte
  • Joel Kallman
  • Howard Rogers

There are no affiliations available

Personalised recommendations