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