SQL & PL/SQL

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!

Can we drop multiple columns, in a table, using single statement?

484123Oct 30 2006 — edited Oct 30 2006

Hi folks,

Here is my gotcha!

I'm trying to drop a column in a table using the typical ALTER statement.
But it is becoming cumbersome in dropping 15 or 20 columns from a 100 column table.
Is there any alternate method in which one statement would suffice the requirement?

Your favour would be deeply appreciated.

Thanks
PCZ

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 27 2006

Added on Oct 30 2006

4 comments

1,206 views