// 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)