ALTER TABLE table_name
MODIFY column_name
varchar(new_length);
// for oracle verison 10 or before
ALTER TABLE table_name
ALTER COLUMN column_name new_data_type(size);
Code language: SQL (Structured Query Language) (sql)
CREATE TABLE t2 (c VARCHAR(10));
Code language: SQL (Structured Query Language) (sql)