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;
TABLE_NAME is your database table name.
COLUMN_NAME is your database column on the table.