I'm trying to delete a column from a view but can't seem to be able to do it because apparently is missing a keyword. Can someone tell me what I'm missing?

ALTER VIEW REORDERINFO DROP COLUMN name;

After trying again I got the following:

SQL> ALTER VIEW REORDERINFO
AS SELECT isbn,title, phone
FROM books JOIN publisher USING (pubid);

ERROR at line 2: ORA-00922: missing or invalid option

sql oracle-database oracle11g
Edit
Report