How to DROP COLUMN On Oracle TABLE

Sometimes we need to DROP COLUMN from the database table. But, how it works on Oracle?

First, you must set the column as the unused column.
ALTER TABLE TABLE_NAME SET UNUSED COLUMN COLUMN_NAME;

Second, you must drop the unused column.
ALTER TABLE TABLE_NAME DROP UNUSED COLUMNS;

Note :
TABLE_NAME is your database table name.
COLUMN_NAME is your database column on the table.