Writing a definition of a view should include the following syntax:

CREATE OR REPLACE VIEW [name]
(column, column, column)
AS SELECT column, column, column
FROM  [table_name]
WHERE  condition to create a view