The syntax for modifying a column’s datatype in Oracle is

alter table table_name modify column_name new_datatype;

This entry was posted on Friday, January 5th, 2007 at 3:14 pm and is filed under Database, Web Development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.