举个例子:
现在我要修改JJ_P_LCFH_POINT表的TEXTSTRING字段为100,改字段类型为VARCHAR2类型:
update column_registry set Column_size=100 where table_name ='JJ_P_LCFH_POINT'
and Column_name='TEXTSTRING';
alter table JJ_P_LCFH_POINT modify TEXTSTRING VARCHAR2(100);
举个例子:
现在我要修改JJ_P_LCFH_POINT表的TEXTSTRING字段为100,改字段类型为VARCHAR2类型:
update column_registry set Column_size=100 where table_name ='JJ_P_LCFH_POINT'
and Column_name='TEXTSTRING';
alter table JJ_P_LCFH_POINT modify TEXTSTRING VARCHAR2(100);