Drop/Remove Column in Oracle Table

Here’s a quick post on how to drop a column/field in a table.

Dropping One Column
alter table
table_name
drop column col_name1;

Dropping Multiple Columns

alter table
table_name
drop (col_name1, col_name2);

Simple, eh?

Related posts:

1. Rename Table in Oracle
2. Convert Rows to One Column
3. Force Table Scan in SQL Server/Sybase
4. Select Random Records in Oracle
5. Oracle CASE WHEN Statement