oracle sql delete a column 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;