add column table pl sql
snippet in sql

alter table oracle

user5316

ALTER TABLE tablename MODIFY columnname varchar2(100)

add column table pl sql

user1167

ALTER TABLE table_name
  ADD column_name column_definition;