How to Add, Drop & Rename Column via SQL

Add Column

alter table xxx_location_t add   varchar2(100)

      

Drop Column

alter table  xxx_location_t drop column l_message

Rename Column

alter table xxx_location_t  rename column process_flag to us_process_flag