In Oracle, you can use the modify statement to modify the field length of the table. The syntax is "alter table table name modify field name field type field length;". The midify statement can not only modify the field length, but also modify the field type, default value, and comments.
The operating environment of this tutorial: Windows 7 system, Oracle version 11.2.0.1.0, DELL G3 computer.
1. Modify one column
alter table 表名 modify name varchar2(60);
2. Modify multiple columns
alter table 表名 modify (name varchar(60),name1 varchar2(60));
Recommended (free): oracle
The above is the detailed content of How to modify table field length using oracle. For more information, please follow other related articles on the PHP Chinese website!