The
University
of
Vermont
Views
A VIEW behaves just like a table. SELECT column, column
FROM view-name WHERE conditions
A view is created through a SELECT statement.
CREATE VIEW perm_addresses as (SELECT * FROM
SATURN.SPRADDR WHERE SPRADDR_ATYP_CODE = 'AP');
A VIEW is a "logical" table.
|