Oracle Sql modify a field in a database table may be empty

2010-11-20  来源:本站原创  分类:Database  人气:199 

Because of the need to modify an existing table column does not allow for the change can be Null Null, the Internet can be found in
ALTER TABLE table1 ALTER COLUMN [name] varchar (60) NULL;
Does not apply to Oracle, Oracle should use the following form:
ALTER TABLE TABLENAME MODIFY COLUMNNAME COLUMNTYPE NULL;

TABLENAME: table name
COLUMNNAME: Field Name
COLUMNTYPE: field type

相关文章