to drop column of view
hello all
i would like to drop one of column of view.
but i unable to drop.
ashish>alter view magazine drop column author;
alter view magazine drop column author
*
ERROR at line 1:
ORA-00905: missing keyword
but same process i had done on table which work.
ashish>ed
Wrote file afiedt.buf
1* alter table magazines drop column author
ashish>/
Table altered.
can u please tell me why i m fail to do so??
with regards
ashish