how to alter table add column with default value in oracle code example
Example 1: alter table oracle
ALTER TABLE tablename MODIFY columnname varchar2(100)
Example 2: PL SQL MODIFY COLUMN NME
ALTER TABLE table_name
RENAME COLUMN old_name TO new_name;