how to drop a column in sqlplus code example
Example: drop colum oracle 18c
-- tested on oracle 18c
alter table table_name drop column column_name;
-- example
alter table products drop column category;
-- tested on oracle 18c
alter table table_name drop column column_name;
-- example
alter table products drop column category;