orcale sql change column type
snippet in sql

sql alter column size

user9709

ALTER TABLE table_name
ALTER COLUMN column_name datatype;

orcale sql change column type

user4776

ALTER TABLE table_name 
MODIFY column_name action;

how to change data type in oracle

user1502


ALTER TABLE table_name

MODIFY column_name datatype; 

alter column type

user9386


ALTER TABLE table_name

ALTER COLUMN column_name datatype;