KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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
Tags (comma-separated)
Save Edits
Cancel