Chapter 10. Using Database and Materialized Views
Views are virtual tables that are derived at runtime. A view is a specification consisting of a SELECT statement that tells Oracle what records and attributes to retrieve. Views are used as the name of a table in an SQL statement. When an SQL statement calls the view, Oracle executes its SELECT statement and then returns the result set to the calling SELECT statement. A view acts like a table but does not store data. Views return derived data only when they are called.
There are three types of views. The first type consists of a SELECT statement that is embedded in the FROM clause of another SELECT statement. This type of view is called an inline view (or derived table). Like all views, it replaces ...
Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
