Check out example codes for "drop colum oracle 18c". It will help you in understanding the concepts better.

Code Example 1

-- tested on oracle 18c
alter table table_name drop column column_name;

-- example
alter table products drop column category;

Learn ReactJs, React Native from akashmittal.com