oracle delete column code example

Example 1: delete column from table oracle PL SQL

ALTER TABLE table_name DROP COLUMN column_name;

Example 2: oracle alter table delete column

alter table table_name drop column column_name;
alter table table_name drop (column_name1, column_name2);