how to delete a column in oracle sql code example
Example 1: delete column from table oracle PL SQL
ALTER TABLE table_name DROP COLUMN column_name;
Example 2: drop colum oracle 18c
-- tested on oracle 18c
alter table table_name drop column column_name;
-- example
alter table products drop column category;