Dropping multiple columns in just one statement?
As far as can tell it is not possible.
I have looked at this link.
http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_3001.htm#i2103924
I thought I might be able to drop multiple columns with a statement like this:
ALTER TABLE HF_movie_table
DROP COLUMN drama
,DROP COLUMN comedy
,DROP COLUMN action
,DROP COLUMN gore
,DROP COLUMN scifi
,DROP COLUMN for_kids
,DROP COLUMN cartoon
;
But that gives error SQL Error: ORA-00933: SQL command not properly ended
As far as I can tell I must drop the columns one at a time unless I want to use a PL/SQL script.
like
ALTER TABLE HF_movie_table DROP COLUMN drama;