Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dropping columns

859365Aug 12 2011 — edited Aug 16 2011
I created a script as follows:

alter table aa
drop (cola, colb, colc);

alter table bb
drop (cola, colb, colc);


I get an error that I need ";" or "/" after drop. I don't understand the need for this. Can anyone give me the syntax to drop multiple columns from multiple tables. And what is the syntax for adding multiple columns to multiple tables?

I had tried the following for about 50 tables. It looked like it worked for about 5 tables, then it aborted.

alter table aa
add (cola char(1), colb char(1));
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 13 2011
Added on Aug 12 2011
4 comments
331 views