The CREATE VIEW statement creates a view. A view is like a virtual table that provides a different way of looking at the data in one or more tables; views are named specifications of a result table. The specification is a SELECT statement that is run whenever the view is referenced in an SQL statement. A view has columns and rows just like a table. All views can be used just like tables for data retrieval.
Example
CREATE VIEW TEST_VIEW (VIEW_I, VIEW_C, VIEW_ID) AS SELECT I, C, ID FROM TEST;