ORA-01730: invalid number of column names specified
Cause: The number of column names specified in a CREATE VIEW statement did not correspond to the number of columns listed in the SELECT clause. If column names are specified in a CREATE VIEW statement, exactly one name must be specified for each column or expression in the SELECT clause.
Action: Specify one view column name for each column in the SELECT clause.