Add, Drop and Rename Columns From Table In Oracle Database

 To Add Column

ALTER TABLE &table_name
ADD (&column_name &data_type);

To Drop Column

ALTER TABLE &table_name

DROP COLUMN &column_name;

To Rename Column

ALTER TABLE table_name

RENAME COLUMN old_column_name TO new_column_name;