To DROP A COLUMN in an existing table, the Oracle ALTER TABLE syntax is:
ALTER TABLE table_name DROP COLUMN column_name;
Let’s look at an example that shows how to drop a column in an Oracle table using the ALTER TABLE statement.
ALTER TABLE customers DROP COLUMN customer_name;
This Oracle ALTER TABLE example will drop the column called customer_name from the table called customers.