how to add a column in a table oracle code example
Example 1: oracle add column
ALTER TABLE table_name
ADD column_name data_type constraint;
Example 2: alter table oracle
ALTER TABLE tablename MODIFY columnname varchar2(100)
ALTER TABLE table_name
ADD column_name data_type constraint;
ALTER TABLE tablename MODIFY columnname varchar2(100)