How to alter table to drop multiple column in Oracle

Fire below commands to Drop one or more columns from a table in Oracle.

1. Drop one column from a table in Oracle.
ALTER TABLE table_name DROP COLUMN column_name; 

 2. Drop multiple columns from a table in Oracle.
ALTER TABLE table_name DROP (column1,column2,column3); 

For more tips and tricks on Oracle, click here.