alter table with add option can be used to add
snippet in sql

alter table with add option can be used to add

user4786

 ALTER TABLE table_name
              ADD (Columnname_1  datatype,
              Columnname_2  datatype,
              …
              Columnname_n  datatype);