Creates a view definition. A view is a logical structure that
refers to rows stored in other tables. Data in a view is not
physically stored in the database. You can include in a view
definition combinations of rows and columns from other tables and
view definitions in the schema. You define a view by specifying a
select expression, that:
o Names the criteria for selecting the tables, rows, and columns
for the view
o Specifies a set of columns from those tables
When the CREATE VIEW statement executes, SQL adds the view
definition to the physical database. If you declared the schema
with the PATHNAME argument, the definition is also stored in the
repository.
Additional Information:
explode
extract