how to change column type in pl sql code example
Example 1: alter table oracle
ALTER TABLE tablename MODIFY columnname varchar2(100)
Example 2: orcale sql change column type
ALTER TABLE table_name
MODIFY column_name action;
ALTER TABLE tablename MODIFY columnname varchar2(100)
ALTER TABLE table_name
MODIFY column_name action;