August 2002
Intermediate to advanced
528 pages
10h 12m
English
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 ...