oracle alter table column type code example
Example 1: add column table pl sql
ALTER TABLE table_name
ADD column_name column_definition;
Example 2: orcale sql change column type
ALTER TABLE table_name
MODIFY column_name action;
ALTER TABLE table_name
ADD column_name column_definition;
ALTER TABLE table_name
MODIFY column_name action;